dynamic sql and oracle forms

[Quoted] [Quoted] I would like to print a dynamic sql-Statement to a file. The problem is following....

[Quoted] SELECT 'INSERT INTO tableVALUES
[Quoted] [Quoted] ('''||table_element1||''','''||table_element2||''','''||table_element3||''') ;' into zus_rev_String
[Quoted] FROM table;

[Quoted] "But when the sql-Statments returns more than one line ==> error, because zus_rev_String is a varchar2.
[Quoted] but text_io.put_line needs a string or varchar."

out_file := Text_IO.Fopen(filename, 'w');

Text_IO.Put_line(out_file, zus_rev_String); Text_IO.Fclose (out_file);

How is it possible to write a dynamic sql-statment to a file (with more than one line).

greetings Martin Received on Tue Jun 25 2002 - 11:57:00 CEST