pls-00553 when 'Set Serverout On' in glogin.sql

2002-08-21 Thread Madhusudhanan Sampath

(reposting)
--
List,

Are we not supposed to 'Set Serveroutput On' in the glogin.sql file?

If the parameter is set in glogin.sql, I'm getting the following error when 
using DBMS_OUTPUT in pl/sql

SQL Create or Replace Procedure TEST1 as
 Begin
 DBMS_OUTPUT.PUT_LINE('TEST');
 End;

Compiles ok, but presents error during run-time.

PLS-00553 character set name is not recognized

(8.1.6.0 on NT4 SP6; am testing this on a small DB/OS Server)

Regards
Madhu




_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhusudhanan Sampath
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



pls-00553 when Set Serverout On in glogin.sql

2002-08-16 Thread Madhusudhanan Sampath

List,

Are we not supposed to 'Set Serveroutput On' in the glogin.sql file?

I'm getting the following error when using DBMS_OUTPUT in pl/sql if the 
parameter is set in glogin.sql.

SQL Create or Replace Procedure TEST1 as
 Begin
 DBMS_OUTPUT.PUT_LINE('TEST');
 End;

Compiles ok, but presents error during run-time.

PLS-00553 character set name is not recognized

(Environment is 8.1.6 on NT4 SP6; am testing this on a small DB/OS Server)

Regards
Madhu



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhusudhanan Sampath
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).