Sorry,I forgot to mention this in my earlier mail,but the approach suggested by you is working. However I want to bind a parameter with some values and the problem is coming there. I hope I am making the problem clearer..
Thanks, Ramakant -----Original Message----- From: Mitsuda, Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:01 PM To: 'Agarwal, Ramakant'; '[EMAIL PROTECTED]' Subject: RE: doubt Try delimiting each element of the in clause, i.e. ...in ('a','b') -----Original Message----- From: Agarwal, Ramakant [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Tuesday, September 10, 2002 9:25 AM To: '[EMAIL PROTECTED]' Subject: RE: doubt Hi, I did not get any answer to my first question and asking for one more doubt. The problem is that I have a query some thing like this "select <fields> from <table_name> where <field_1> in <set_of_values>" The problem is that this query is working fine when there is only one value in the set_of_values ,for ex. "a" but if I have more than 1 value in the value set then it is not not giving any result,for ex "a,b" I tested the query using both ora perl and Perldbi but nothing is working. Can anyone please help me out? Thanks in advance.. P.S. Please let me know if you want any relevant details regarding this or if the problem is not clear. Thanks, Ramakant -----Original Message----- From: Agarwal, Ramakant Sent: Wednesday, September 04, 2002 7:54 PM To: [EMAIL PROTECTED] Subject: RE: doubt Hi, I have some stored procedure/function in oracle and it returns the result through ref cursor. I want to know if we can use perl scripts to invoke this procedure and get the result using ref cursor. Can you please help?? Thanks, Ramakant This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmission. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. All e-mails at Neuberger Berman are, in accordance with Firm policy, to be used for Neuberger Berman business purposes only. E-mails sent from or to the Firm are subject to being reviewed by the Firm in accordance with the Firm's procedure for the review of correspondence.
