Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Passing structure to PL/SQL package/procedure via Pro*C
Hi,
Is it possible to pass in and out a structure to a procedure/package in Embedded PL/SQL block?
Assuming I have the following codes:
create type struct_obj is object (
prefix varchar2(3),
no integer,
);
create type struct_tbl is table of struct_obj;
I used the OTT to generate a header file from the above types.
When I precompile the follwoing codes, I get error PLS-S-00306, wrong number
or types of arguments in call to 'proc'.
EXEC SQL EXECUTE
BEGIN
pkg_test.proc(:my_struct);
END;
END-EXEC;
I tried passing a C structure to the procedure also hitting the same error.
Could any one help?
Thanks,
Max
Received on Thu Oct 02 2003 - 02:07:27 CDT
![]() |
![]() |