Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Proc*C: how to pass structure to stored procedure?
Hi All,
I have a stored procedure that takes a type record as an input. This type record closely resembles a C++ structure in my Pro*C program.
Is there a way to pass the structure to the stored procedure called in a PL/SQL block in my program, other than building a host variable for each member in the structure, copy each member from C++ structure to host variable, and finally, in PL/SQL block: assigning host variable to corresponding fields in type record???
Although this works, this structure has 25-30 members, and what I really want to pass to the stored procedure is an ARRAY of structures. Possible???
TIA,
Dave
Received on Tue Jul 13 1999 - 17:39:27 CDT
![]() |
![]() |