my typical requirement

Get new comments by email
You can cancel email alerts at anytime.
Comments (2)

rajesh in Huy, Belgium

39 months ago

Hi everyone,

Can anyone help me on the following requirement,

I need to generate a select query in run time and store the results of it into a file.Each time the column name and table name in the query will differ.Now im able to generate the select query through for cursor but problem is to store the results to the file.I tried using plsql table,im able to get the values to that table and store the results to a file,but the results of the query is more then 10000 lines (it might increase also)where only 4000 characters where able to store in the plsql table.

so rest of them are not stored in the file.

Please give your suggestions.

- Was this comment helpful? Yes / No Reply - Report abuse

MANJU RAJENDRAN in Worcester, Massachusetts

37 months ago

You require a Clob data type
insert it to the clob , dbms_lob package comes handy .
Use the dbms_xslprocessor function to store it as text .

If you need a sample email me
winneroracle@mail.yellostone.net

Thanks
Manju

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.