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

Home -> Community -> Usenet -> c.d.o.tools -> oci stored procedure parameter bind

oci stored procedure parameter bind

From: John Bullock <jbullock_at_neo.rr.com>
Date: 18 Jun 2001 01:53:11 -0700
Message-ID: <bfd9866f.0106180053.32c895cc@posting.google.com>

I am trying to get a standard C application to call an existing database stored procedure using the OCI library. The program uses function "obndra" to bind a parameter declared as "IN OUT" and "TABLE OF VARCHAR2(16)" to a two dimensional C char array. When the application is run, the following error is reported:

error 1485 "compile bind length different from execute bind length"

If I modify the stored procedure parameter to be OUT only, the C app works fine.

Can anyone tell me if you can bind to an "IN OUT" parameter this way?

I would like to know if it's even possible to bind to an "IN OUT" procedure parameter using "obndra". I have not included copies of the software here because the application can be made to work, although it would be more effective to leave the existing stored procedure as is. I will supply stored procedure and C code upon request if more information is required.

Thanks in advance for any help you can give. Received on Mon Jun 18 2001 - 03:53:11 CDT

Original text of this message

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