473,322 Members | 1,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

dbms_output.putlin show up AFTER completion???

Hello all,

I have made a procedure which is running a very, very long time (about
20 hours)

Within the procedure I put some output-lines, to show the user that
the procedure is still running. Lines like this
DBMS_OUTPUT.PUT_LINE('percentage ready : '!!mypercentage);

But when I start the procedure I DO NOT see these lines. The lines do
appear AFTER the procedure is finished. So after 20 hours I get a lot
of output-lines at once.

How can I show the user the lines while running the procedure???

(Using oracle 8.1.7, I am starting the procedure from sql+ (exec
myserver.myprocedure))
Thanks a lot and kind regards,
Andre van Rossem
The Netherlands
Jul 19 '05 #1
1 3601
Congratulations,
you just discovered (the hard way, unfortunately!) probably the
biggest drawback of PL/SQL! What you have to do is rely on something
else than DBMS_OUTPUT.PUT_LINE to find out where you are in your
subroutine. I personally usually make use of
DBMS_APPLICATION_INFO.SET_MODULE spread through the code to see where
my PL/SQL block is at. If using this, you need to look in V$SESSION
(columns ACTION and MODULE) to see where the program is. One more
option is to use DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS (you then
spy on the dynamic view V$SESSION_LONGOPS to see where you're at). 20
hours seems like a very long time for a procedure. What about posting
your code so that we can give some ideas for performance improvement?
Or you can email me if you want.

Daniel (remove JUNK from my email address to reach me).
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Agoston Bejo | last post by:
Is there any way to reach the content of the DBMS_OUTPUT buffer after calling an Oracle stored procedure from ASP/ADO?
2
by: Agoston Bejo | last post by:
Is there any way to reach the content of the DBMS_OUTPUT buffer after calling an Oracle stored procedure from ASP/ADO?
1
by: srinivas | last post by:
Hi, First i need to say my heartful thanks to google groups.So many things are clarified by some of the experts. Now I have a requirement.Basically our site have 5 pages.When we navigate to...
5
by: nsd | last post by:
Is there any equivalent of oracle's dbms_output.put_line in db2? Pl. let me know if any.. regards, nsd
5
by: Robert Heuvel | last post by:
Hi, this is what I did: public struct SWaitCursor:IDisposable { public SWaitCursor (int i) { Cursor.Current = Cursors.WaitCursor; } void System.IDisposable.Dispose() { Cursor.Current =...
22
by: Zytan | last post by:
I have public methods in a form. The main form calls them, to update that form's display. This form is like a real-time view of data that is changing. But, the form may not exist (it is...
3
by: Chris | last post by:
I have a python script that is driving Excel and using the win32com module. However, upon program completion there's still an Excel.exe process running in the background that I must terminate...
1
by: Andre | last post by:
Hello all, I have made a procedure which is running a very, very long time (about 20 hours) Within the procedure I put some output-lines, to show the user that the procedure is still running....
1
DebadattaMishra
by: DebadattaMishra | last post by:
Introduction In case of rich applications, you must have observed that a text field behaves like a dynamic combo box. When the user enters some characters in the text field, a popup will come up...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.