OraFAQ Forum: SQL & PL/SQL » Re: returning ref cursor variables from oracle

Home » SQL & PL/SQL » SQL & PL/SQL » Re: returning ref cursor variables from oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

----------------------------------------------------------------------

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:04:33 CST 2024