Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problem with PRO*C and PL/SQL-Procedure
Hi Folks,
I have the following problem when working with PRO*C and PL/SQL procedures:
I have declared an PL/SQL procedure using a SELECT statment with the WHERE condition
'WHERE column IN ( :variable )'
In my C program I bind the variable :variable to a character string with values, for example
'123,456,789'. No I expect, that the PL/SQL
procedure selects all rows of a table where the column 'column' has the value 123 or 456 or 789. But if I run my C program I get the error PLS 418. What am I doing wrong?
Please send answers to my e-mail adress or post them in this news group.
Thanks to every respond,
Andy.
-- --- ___ ___ ___ ___ ___ ___ ___ Dr. Andreas Listl | || || || || || || | Dipl.-Inform. | d || i || g || i || t || a || l | Information Management |___||___||___||___||___||___||___| Tel.: ++49 89 9591 2821 Digital Equipment GmbH Fax.: ++49 89 9591 2575 Postfach 81 02 47 mail: listl_at_rto.dec.com 81902 MuenchenReceived on Wed Dec 11 1996 - 00:00:00 CST
![]() |
![]() |