Home » SQL & PL/SQL » SQL & PL/SQL » Re: returning ref cursor variables from oracle
Re: returning ref cursor variables from oracle [message #36389] Sat, 24 November 2001 03:19
Avinash Sharma
Messages: 1
Registered: November 2001
Junior Member
Hi,
I am facing a similar problem but some different.I am making an application which is totally dynamic. each and every statment of this application will be totally dynamic.
Now the problem is I donot know the the name and the number of columns in a table at complile time.So obviously I will use ref cursor because I even I do not know the name of table.Now I create a select statment dynamically.i execute it using a ref cursor.
Now the problem is I want to process the each field of a row.I canot use the INTO clause in fetching fields of rows because I do not have the exact number of columns.

Pls suggest me
thanks
Regards
Avinash

----------------------------------------------------------------------
Previous Topic: How to insert a String type parameter while it should be Integer?
Next Topic: Inserting info with punctuation into a table.
Goto Forum:
  


Current Time: Fri Mar 29 07:41:17 CDT 2024