Home » SQL & PL/SQL » SQL & PL/SQL » ref cursosr
ref cursosr [message #36567] Tue, 04 December 2001 21:50 Go to next message
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 Go to previous message
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;

----------------------------------------------------------------------
Previous Topic: Test for Numeric Function
Next Topic: integrate sqloader with VB or C
Goto Forum:
  


Current Time: Tue May 28 05:40:10 CDT 2024