SQL Plus Not Working With DBMS_OUTPUT

[Quehay]

I've got Oracle 8.1.5 on XP (NT). It has worked just fine previously but now I'm getting if SERVEROUTPUT is on (and of course I need it on)

PLS-00553: character set name is not recognized

I've got PC settings at English/US.

Thanks for any insight into this!

[tt]

SQL> set serveroutput off
SQL> exec dbms_output.put_line('test');

PL/SQL procedure successfully completed.

SQL> set serveroutput on;
SQL> exec dbms_output.put_line('test');
ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
[/tt]


PL/SQL procedure successfully completed.

 

[Quehay]

OK...so a restart of SQL Plus fixed it. When in doubt reboot...

 

[shinkley]

you have a semi-colon after your set serveroutput on stmt

 

[SantaMufasa]

Shinkey,

And the harm is.....?

 

[sem]

First of all 8.1.5 is not supported on XP. Then, 8.1.5 is TOO buggy. And at last, this may be a known bug: do you launch your code from the same session that started database?

Regards, Dima

 

[Quehay]

Thanks Dima! This is just a home copy so I can work on getting my PL/SQL chops together--no real data work here.
I log on internal to start up , then issue CONNECT uname/pwd. This error has occurred since when I try to set OUTPUT on and then use dbms_output. Again, closing SQL Plus and starting it fresh after the DB has been mounted seems to fix it.


Jeffrey R. Roberts
Insight Data Consulting
Access, SQL Server, & Oracle Development

http://www.insightdataconsulting.com