companyproductsserviceandsupportpartnersresourcesforumstore
SQL Power Forum - Unleash The Intelligence Within
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

[Register] Register / 
[Login] Login 
Power loader - Execution of SQL scripts  XML
Forum Index » SQL Power Loader Suggestions
Author Message
ibhayat


Joined: 2007-09-13 13:09:20
Messages: 36
Offline

Is it possible to log the SQL output into the logfile when executing pre/post or transaction SQL packages or scripts.

Thanks
jaw


Joined: 2007-01-05 10:40:58
Messages: 96
Offline

what kind of output you are looking for? the engine should be able to capture the output of SQL*PLUS if you run a script in a job, and I think it should be able to get the dbms.outline of package, but maybe be only true for stored procedure in a job, and maybe you can try debug mode.
ibhayat


Joined: 2007-09-13 13:09:20
Messages: 36
Offline

We are looking to store the output of the sql execution in a log file.
jaw


Joined: 2007-01-05 10:40:58
Messages: 96
Offline

call your sql script from a batch script, that should do it.
 
Forum Index » SQL Power Loader Suggestions
Go to:   
Powered by JForum 2.1.8 © JForum Team