Re: pl/sql problems
Date: Thu, 9 Jun 1994 15:04:37 GMT
Message-ID: <Cr4xvp.M9x_at_netnews.whoi.edu>
In article 2155_at_newsserver.rrzn.uni-hannover.de, gsuck_at_rvs.uni-hannover.de (Thomas Gsuck) writes:
>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...
Yuuuuck!
>Is there any other way known to produce output ?
>Otherwise I'll have to switch to Pro*C, what my boss does not like....
I ran into the same problems...
I wanted to write several reports using data stored in Oracle. The lack of I/O in PL/SQL turned me off right away. Oracle's report writter is not powerful enough for the things I wanted to do. Pro*C was a nice alternative, but there was no builtin report writing capability, I would have to write functions to handle page breaks, page numbers, etc. That's why I'm glad I found "oraperl"; the Perl interface into Oracle. Perl has some pretty good report writing features (headers, formating of detail lines, page numbers, etc) and it in itself is a pretty powerful language. Depending on what you want to do, this may be right for you.
David Hiltz
dhiltz_at_whsun1.wh.whoi.edu
Network System Administrator
Northeast Fisheries Science Center
######&_at_&###### Received on Thu Jun 09 1994 - 17:04:37 CEST