Home » Developer & Programmer » Precompilers, OCI & OCCI » PRO C
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
Previous Topic: Generate Generic Log Output with Precompiler
Next Topic: Data lost after adding Null terminator for VARCHAR data recieved from database
Goto Forum:
  


Current Time: Fri Mar 29 08:54:19 CDT 2024