Re: DBMS_OUTPUT.PUT_LINE

Magnus S. Petersen wrote:

> Working with Delphi3 C/S and Personal Oracle.
> How can i retreive in Delphi from say a stored procedure the text from
> DBMS_OUTPUT.Put_line.
>
> I have a procedure with the following
> EXCEPTION
> WHEN NO_DATA_FOUND
> THEN
> DBMS_OUTPUT.PUT_LINE('A text of some kind');
>
> I want to acces this in Delphi, but cannot find out how to do it. Can anyone
> assist ?

You need not in DBMS.PUT_LINE, but in RAISE_APPLICATION_ERROR (I don't shure is this name is correct , look in manual)

for DBMS_OUTPUT.PUT_LINE, I guess, you must use direct OCI calls.

> Regards
> Magnus

--

    @=
     //RSSH                              mailto:Ruslan_at_Shevchenko.Kiev.UA