Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_OUTPUT.PUT_LINE
I'm not sure you can - the output is probably sent to it's own internal buffer, which is only flushed when the call completes.
I'd also question whether this was the best way to approach this problem... Why not return the string via a function (or an OUT parameter for a procedure) and just use a stored procedure call from Delphi? (If Delphi can do this? I've never used Delphi, but have used this approach successfully with many other client-server tools.)
Just my thoughts.
Steve Phelan.
Magnus S. Petersen wrote in message <6e19gb$lia$1_at_news.uni-c.dk>...
>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 ?
>Regards
>Magnus
>
>
>
Received on Tue Mar 10 1998 - 00:00:00 CST