SET SERVEROUTPUT ON doesn't work
Steven Kell
I'm new to Oracle and PL/SQL, and was writing a simple procedure, when I
decided that I'd like to see some debugging type info. I tried the
DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried DBMS_OUTPUT.ENABLE,
and that didn't work either. I then tried SET SERVEROUTPUT ON, and that gave
the following message:
SQL> set serveroutput on;
ERROR:
ORA-06550: line 1, column 19:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
So, what gives? This is supposed to be a "standard" Oracle function/package,
isn't it? If anyone out there has any ideas, I'd be glad to hear them.
Thanks!
mla...@vnet.ibm.com
There is a script in /rdbms72/admin subdir called dbmsotpt.sql that creates
the dbms_output package. Run it connected as SYS. BTW, this script is
usually ran when installing the procedural option. Have you
been able to create a pl/sql procedure without errors?
If not, run catproc.sql in the same sub-directory connected as SYS.
M.Landa
Scott T. Johnson
Setting SERVEROUTPUT ON should work, if this is set outside the PL/SQL
code. I was never successfull at getting DBMS_OUTPUT.ENABLE to work but
you don't need both statements for DBMS_OUTPUT to work.
Maybe someone else can tell us why DBMS_OUTPUT.ENABLE doesn't work.
Scott
Craig Ewing
What you need to do is provide a parameter value. Try --
DBMS_OUTPUT.ENABLE(1000000);
Venkateswara R Polisetti
sk...@binc.net (Steven Kell) wrote:
>I'm new to Oracle and PL/SQL, and was writing a simple procedure, when I
>decided that I'd like to see some debugging type info. I tried the
>DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried DBMS_OUTPUT.ENABLE,
>and that didn't work either. I then tried SET SERVEROUTPUT ON, and that gave
>the following message:
>SQL> set serveroutput on;
>ERROR:
>ORA-06550: line 1, column 19:
>PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>So, what gives? This is supposed to be a "standard" Oracle function/package,
>isn't it? If anyone out there has any ideas, I'd be glad to hear them.
>Thanks!
I think you do not have the dbms_output package installed on your
system. Execute the following query to check to see if it exists.
SELECT *
FROM all_objects
WHERE object_name = 'DBMS_OUTPUT';
If the above query does not return any rows then you donot have the
package installed on your system.
To install the packege run the following script in the directory :
$ORACLE_HOME/rdbms/admin/dbmsotpt.sql
as SYS user.
Good luck,
Venkateswara Rao
/-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-\
| Venkateswara R.Polisetti Email: vr...@sctcorp.com |
| SCT Utility Systems, Inc. Phone(O): (803) 935-8160 |
| 9 Science Court (R): (803) 736-1609 |
| Columbia, SC 29203-9344 |
\-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-/
John Kessel
Steven Kell schreef aan All:
SK> From: sk...@binc.net (Steven Kell)
SK> Date: 24 Aug 1996 19:27:23 GMT
SK> Organization: Berbee Information Networks Corporation
SK> I'm new to Oracle and PL/SQL, and was writing a simple procedure,
SK> when I decided that I'd like to see some debugging type info. I
SK> tried the DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried
SK> DBMS_OUTPUT.ENABLE, and that didn't work either. I then tried SET
SK> SERVEROUTPUT ON, and that gave the following message:
SQL> set serveroutput on;
SK> ERROR:
SK> ORA-06550: line 1, column 19:
SK> PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
SK> ORA-06550: line 1, column 7:
SK> PL/SQL: Statement ignored
SK> So, what gives? This is supposed to be a "standard" Oracle
SK> function/package, isn't it? If anyone out there has any ideas,
SK> I'd be glad to hear them.
Maybe you used the previous version of Oracle.
I did the same today and with the same results.
Or has anyone a better solution ????
John
--
| Standard disclaimer: The views of this user are strictly his own.
Carl Tichler
It appears that the DBMS_OUTPUT package was not loaded. The DBA
has to load this package --- it is part of "catproc.sql", I believe.
Carl Tichler
cat...@cloud9.net
>I'm new to Oracle and PL/SQL, and was writing a simple procedure, when I
>decided that I'd like to see some debugging type info. I tried the
>DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried DBMS_OUTPUT.ENABLE,
>and that didn't work either. I then tried SET SERVEROUTPUT ON, and that gave
>the following message:
>SQL> set serveroutput on;
>ERROR:
>ORA-06550: line 1, column 19:
>PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>So, what gives? This is supposed to be a "standard" Oracle function/package,
Arif Zaman
In article <1996Aug26....@nosc.mil>, ewi...@nosc.mil (Craig Ewing) says:
>
>What you need to do is provide a parameter value. Try --
>DBMS_OUTPUT.ENABLE(1000000);
>
>>decided that I'd like to see some debugging type info. I tried the
>>DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried DBMS_OUTPUT.ENABLE,
>>and that didn't work either. I then tried SET SERVEROUTPUT ON, and that gave
>>the following message:
>
>>SQL> set serveroutput on;
>>ERROR:
>>ORA-06550: line 1, column 19:
>>PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
>>ORA-06550: line 1, column 7:
>>PL/SQL: Statement ignored
>
>>So, what gives? This is supposed to be a "standard" Oracle function/package,
>
>>Thanks!
>
>
>
>
Hi Craig
It seems to me that your oracle database may have been installed in
a piece meal fashion. The fact that you can not run the above procedures
indicates that these procedures do not exist in your database.
This is what you need to do to get all these sorted out:
1. Connect to SYS account and run catalog.sql. This will take
time but install all the available options.
or
2. Connect to SYS account and run dbmsotpt.sql . This will create
all the necessary procedures and functions that are required for
the thing you're trying to do.
Good Luck
Arif