Hi,
I have to spool a lot of (XML) text from within a sqlplus session to a file (unfortunately I can
not use UTL_FILE).
Because I found no way to pull out the complete XML string at once with sqlplus
I wrote a function which returns a CLOB value. Inside sqlplus I declare a variable and
assign the return value of the function to this variable. Then I do a "print my_varaible" in
sqlplus.
However I can suppress to undeline-line with "SET UNDERLINE OFF" but found
no way to suppress the heading for the "print" command. Here comes the snippet:
EXEC :my_variable := xmlprint
/* here I'm searching for a cool command */
print my_variable
Result is:
snip
MY_VARIABLE
<myxml>...</myxml>
snip
but I want only
<myxml>...</myxml>
BTW, how large can a sqlplus binding variable grow ?
Because I declared it as CLOB I assume it can grow to 4 GB ?!
see Oracle 9.2 documentation:
...CLOBs can store up to 4 gigabytes of character data. ...
Best regards,
Thomas