ref cursosr [message #36567] |
Tue, 04 December 2001 21:50 |
asha
Messages: 3 Registered: December 2001
|
Junior Member |
|
|
the problem that i am facing is as follows.
i need to pass variable colums to ( 'col1||col2||col3......' )
to a stored procedure which should inturn return a cursor (the select is done depending on the columns send )
how can this be done .
thanx in adv
Asha
----------------------------------------------------------------------
|
|
|
Re: ref cursosr [message #36576 is a reply to message #36567] |
Wed, 05 December 2001 05:29 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
pass values to parameters and inside procedure build sql statement , return ref cursor using open ref_curname for sql_stmt;
----------------------------------------------------------------------
|
|
|