Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> oci stored procedure parameter bind
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
![]() |
![]() |