Re: pl/sql problems

The dbms_output package work very well inside PL/SQL. You have to make sure the following is done:

• The dbms_output package has been created (sounds like yours isn't). RTM for this one. (just be sure you SYS user)
• In sqlplus, you set the output on. If not putline()'s are ignored. *THE ORACLE DOCUMENTATION IS WRONG* on setting this option. It is "set serveroutput on" (the docs show "set server output on" and "set server_output on"). This is a session param so you will have to set it each time you go into sqlplus. Note: There is a "startup" file that sqlplus runs for everybody.
• The "buffer" is large enough. The output lines are placed into a buffer. if this buffer isn't large enough you'll get a buffer out of space error. To increase the size use dbms_output.enable(bignum) where bignum is bigger than the default of 1000 bytes. This buffer applies to the sum of *all* lines PL/SQL spits out -- no matter what the docs say.

hmmm... think thats it.

John Dennis
Atlanta, GA Received on Tue Jun 07 1994 - 19:34:25 CEST