Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Advice on Dumping a Cursor to a Text file..
Message
From
31/03/2000 11:25:41
 
 
To
31/03/2000 09:16:05
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00353275
Message ID:
00353379
Views:
16
I think you have a problem there. I cannot think of any way to make a generic cursor. The fields need to be defined at compile time. You might get away with a rather long argument list(tbl_name, field1,field2 fieldn....),and do something like
CURSOR generic IS
tbl_name.field1%TYPE
but even that would not likely work well.
A thought though, is to use the HTML package, and skip the tags to make the csv file, then use UTL_FILE to modify the file.
Previous
Reply
Map
View

Click here to load this message in the networking platform