pl/sql problems

From: Thomas Gsuck <gsuck_at_rvs.uni-hannover.de>
Date: Tue, 7 Jun 1994 12:39:03 GMT
Message-ID: <1994Jun7.123903.2155_at_newsserver.rrzn.uni-hannover.de>


hi out there in netland:

I have some trouble using pl/sql. It lacks i/o like "printf" or sth similar to that. But I need to do some output every now and then. With SQL*Plus I can use "PRINT", but this can only handle ONE variable. The trick with using "dbms_output.putline('Text" || var) does not work within pl/sql. I always get "putline must be declared..." when using this.

The other way would be to collect the answers in a temporary table and THEN query this table with 'select *' in SQL*Plus, but this creates too much overhead and lacks performance...

Is there any other way known to produce output ? Otherwise I'll have to switch to Pro*C, what my boss does not like....

Thanks in advance.
(help by email appreciated)



Thomas C. Gsuck

Regionales Rechenzentrum Niedersachsen
Uni-Hannover
Germany


Received on Tue Jun 07 1994 - 14:39:03 CEST

Original text of this message