Folks,
Unless I'm totally wrong I believe I remember seeing an article on DBMS_OUTPUT
on Metalink that specifically states that it's for use in SQL*Plus for debuging PL/SQL
programs only. Therefore it's rather useless anywhere else.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Tuesday, July 22, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
On Tue, 22 Jul 2003, you wrote:
> Hi Gyuri,
>
> Why not dispense with the dbms_output in main() and simply use printf or
> fprintf? If you want to keep it then you need to call
> dbms_output.enable(1000000); before you call put_line, i have found that
> you also need to call dbms_output.disable; first before the enable
> (never found out why?).
>
> Also in your fAlertWatch function you use printf(buff) to print out the
> buffer in the case of a timeout but when you receive a message you use
> sprintf to format your buffer but then don't print it out?.
>
> hth
>
> kind regards
>
> Pete
Hi Pete,
I use DBMS_OUTPUT because I am curious how it works. When I use printf, there is
no problem with printing on terminal (dbms_output.enable(1000000); doesn't
help). But my main problem is about using alert. I'd like to catch an alert
with a ProC program, but I can't catch. It works in a PL/SQL script, but not in
ProC. Why?
Thanks: Gyuri
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lendvary Gyurika
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
