Any ideas on this out there? No response yet, so, thought I'd repost..I
REALLY need some pointers or ideas here...I'm stuck and can't get past this
point....
----------------------------------------------------------------

Hello all,
I have ref cursor (actually I'm needing to do this a lot) for checking
tables between two databases. I'm making my sql string dynamically as it
does down a list of table_names from another cursor that selects
table_names from a given schema..

Ok..so my ref cursor is being created for example, and a 'select * from
'||v_tablename Now, after I open this cursor...I need to fetch it into
some kind of record...but, how do I declare that if I don't know the type
of record since I don't know what table I will have at that time....

I can programatically get to columns in the cursor....for each table name,
I'm creating a pl/sql table to store the columns for each table I'm working
with in the program. But, I'm stuck with knowing what to fetch INTO so I
can start manipulating them...

Any suggestions? Am I being clear on what I'm trying to do?

TIA,

Kelly




If you had to identify, in one word, the reason why the
human race has not achieved, and never will achieve, its
full potential, that word would be "meetings".


Oracle LazyDBA home page