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


Reply via email to