| dbms_output.put_line synchronize [message #681672] |
Fri, 14 August 2020 08:02  |
wtolentino
Messages: 373
Registered: March 2005
|
Senior Member |
|
|
i have this pl/sql code that takes long to complete. it is writing it's output thru dbms_output.put_line by spool to a file. since the code takes long to complete it wouldn't write anything yet to the file until it finish. is there a way that every time the dbms_outout.put_line executes it will write right away to the file? so that i will know from time to time what is going on while the pl/sql code executes.
i know there is another way by using UTL_FILE but i can't use it because i don't have access to the database server.
thanks,
warren
[Updated on: Fri, 14 August 2020 09:46] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: dbms_output.put_line synchronize [message #681676 is a reply to message #681674] |
Fri, 14 August 2020 13:15  |
 |
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Yes, a very good way, how could I forget it when I used it so much times, I even wrote an article about that (it was in 2006, unfortunately in French, the title was (translated) "The DBMS_APPLICATION_INFO package or how to know what my application is doing")!
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
