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