Re: Problem: calling stored Procedure from Pro*C
From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/10/28
Message-ID: <01bce395$4993b360$54110b87_at_clamagent>#1/1
Date: 1997/10/28
Message-ID: <01bce395$4993b360$54110b87_at_clamagent>#1/1
You can define a C struct with members mapped to each column value, pass each column value through the stored procedure's parameter list (declaring each member separately). While this isn't as clean as passing "records" would be, especially when a table has lots of columns, at least it works. In 7.2 you can also pass REF CURSORS around and do the fetch on the client.
Thomas Kyte <tkyte_at_us.oracle.com> wrote in article
<34591160.8752024_at_newshost>...
> PL/SQL records can only be used in pl/sql. You cannot bind a 3gl record
> directly to a pl/sql record. You can bind individual components of 3gl
records
> to pl/sql record components but not whole records.
Received on Tue Oct 28 1997 - 00:00:00 CET