RE: Using ALERT in a ProC program

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-----
From: Lendvary Gyurika [mailto:gyurika_at_prolan.hu] Sent: Tuesday, July 22, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Using ALERT in a ProC program

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: gyurika_at_prolan.hu

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: ListGuru_at_fatcity.com (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).