| PRO C [message #485977] |
Sun, 12 December 2010 06:40 |
 |
supreeth080
Messages: 1
Registered: December 2010
|
Junior Member |
|
|
Hi All,
I have a problem in calling a procedure from a PRO C file.
The structure of the procedure is:
CREATE OR REPLACE PROCEDURE abcd(a IN NUMBER, b IN DATE, c OUT FLOAT, D OUT sample_type) IS
BEGIN
.........
--PROCEDURE FUNCTIONALITY;
.........
END;
where:
sample_type is a collection type
CREATE TYPE sample_type IS TABLE OF sample_object;
where:
sample_object is an object
CREATE TYPE sample_object AS OBJECT (
x FLOAT;
y VARCHAR(5);
);
Now, I want to call the procedure abcd from a PRO C file.
I want to fetch the value of x FLOAT from the object from PRO C file by calling the procedure.
But the variable d OUT in the procedure is of the type sample_type.
What kind of variable I should use in PRO C file that corresponds to the PL/SQL variable 'd' in the procedure?
Thanks in advance for your help.
Regards,
Supreeth K
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
