Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Proc*C: how to pass structure to stored procedure?

Proc*C: how to pass structure to stored procedure?

From: David Nels <djnels_at_ticketslive.com>
Date: Tue, 13 Jul 1999 18:39:27 -0400
Message-ID: <OoZJWCYz#GA.264@cpmsnbbsa02>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US