spool like under sql+

[ElvisUntot]

when i use oracles sql+ (or oracle worksheet) i can use the commands "spool <filename>" and "spool off" to save a logfile to the drive.

now i need to do a program that gives me a log each sql that is done.
but since "spool" does not seem to be a regular sql-command, i have a problem with that.

does anyone know how to get a log?
(the ora-errors are not enough)

it does not mater if it is rdo, ado or something else.

 

[Dashley]

Elvis,

For a simple log file you can use a plain text file.

Ref this link

http://www.officecomputertraining.com/vbtutorial/tutpages/page24.asp

You can also write the sql to a table in oracle too. Just before the sql excutes stuff it in a table.

Hope this helps

 

[ElvisUntot]

thank you for your help, but it did not help.

i had no problem in opening an textfile, i had the problem in getting a spool from oracle.

anyway, now i open a "sql+" with the help of ShellX (

http://vb-tec.de/xshell.htm)

and so the user(me) can see the spool directly.