Re: DBMS_SQL and DBMS_OUTPUT package

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1997/10/30
Message-ID: <63a3ar$260@bgtnsc02.worldnet.att.net>#1/1

On 29 Oct 1997 14:17:55 GMT, "Haresh Assumal" <assumal_at_sprynet.com> wrote:

>I can create a table without this PL/SQL procedure
>in SQL so the user I am logining as has sufficient privileges and owns the
>procedure too. I am running the procedure from SQL. What's wrong?

I don't know the answer to this one--sorry, but I can answer your second question.

<snip>

>Isn't DBMS_OUTPUT.ENABLE equivalent to running a 'SET SERVEROUPUT ON' ?

No. "Set serveroutput on" tells the SQL*Plus program to display any output returned from the server. The call to dbms_output.enable sets a flag in the dbms_output package causing it to actually generate output when you make calls to put_line, etc.

regards,

Jonathan Gennick

---

gennick_at_worldnet.att.net
http://home.att.net/~gennick Received on Thu Oct 30 1997 - 00:00:00 CST