Re: DBMS_OUTPUT with C-programs

Florian Schmedding wrote:

> Does anybody know how to receive the text output from PUT_LINE commands
> within a PL/SQL procedure in a C program?
> I'm calling the PL/SQL procedures with embedded SQL.
> I can only receive the text output from RAISE_APPLICATION_ERROR
> statements.
>
> Second question:
>
> How can I get a procedure's schema name within the procedure in PL/SQL? Is
> there any function?
>
> Florian

You should not be using put_line but rather returning items with a REF CURSOR, VARRAY, or other structure.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)