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? Received on Tue Jul 22 2003 - 07:51:57 CDT