Home » SQL & PL/SQL » SQL & PL/SQL » From Records to Ref Cursor
From Records to Ref Cursor [message #39199] Tue, 25 June 2002 12:15 Go to next message
Roy
Messages: 30
Registered: May 2002
Member
Hello,

I have a function which returns a Record. Due to some other compatibilty issues with another development environment, I need to Return a Ref Cur. Basically, I am looking for a solution to get the Data from Record data type to Ref Cur and return that Ref Cursor?? Any ideas? will be appreciated..

Thanks,
Roy

Report message to a moderator

Re: From Records to Ref Cursor [message #39200 is a reply to message #39199] Tue, 25 June 2002 12:42 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Not sure if this is the best way - but you could populate a pl/sql table with your records and then query it.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:246014735810

Report message to a moderator

Previous Topic: Re: To PL/SQL Experts: ORU-10028: line length overflow, limit of 255 bytes per line.
Next Topic: Re: SERVICE NAME
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 04:15:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.