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 -> Problem with PRO*C and PL/SQL-Procedure

Problem with PRO*C and PL/SQL-Procedure

From: Andreas Listl <listl_at_rto.dec.com>
Date: 1996/12/11
Message-ID: <32AECDED.2781@rto.dec.com>#1/1

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 Muenchen
Received on Wed Dec 11 1996 - 00:00:00 CST

Original text of this message

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