Re: Can i pass a structure into a pl/sql procedure using ProC?

No, you can't pass a C struct in or a PL/SQL record out. You can list all the columns in the PL/SQL procedure parameter list; You can pass a REF CURSOR (in 7.3 and up) back to C; You can pass in a long string containing the concatenation of all columns, then parse them back out inside the PL/SQL procedure; You can use dynamic SQL to build an anonymous PL/SQL statement containing the PL/SQL procedure call which has all columns on the parameter list (a lot more work).

• Dan Clamage P.S. Oracle is kicking the pants off of Sybase, for a lot of other good reasons. -djc -- T'was Brillig, And the slithy toves Did gyre and gimbol in the wabe; All mimsey were the borogroves, And the mome raths outgrabe.
• Lewis Carroll

David M Rosner <drosner_at_dcn.att.com> wrote in article <34E0BF27.8C5DE49F_at_dcn.att.com>...
> I am writing a set of APIs that totally abstract the data access methods
> by accepting input and output structures. My apis execute a PL/SQL
> procedure (within a package) that opens/closes a cursor and then fetches
> a row. I continue to fetch until i get no more rows, all along
> populating the input structure.
>
> how do i do this? i've seen the code to use embeded sql and C
> structures, but how do i pass a structure to a PL/SQL procedure? The
> manual says that Pl/SQl records can not be used in conjunction with C
> structures.
>
> Is what i'm attempting possible? Why is Oracle so much more difficult to
> work with than sybase?
Received on Fri Feb 20 1998 - 00:00:00 CET