PLS-00553? No source code?? Help please!

From: Paul Brinkley <laugh_at_starpower.net>
Date: Wed, 22 Aug 2001 20:52:00 GMT
Message-ID: <3b841aec.766911830@news.starpower.net>

Tried this from Ye Olde SQLPlus Prompt:

sql> create table foo (a int);

sql> create procedure bar is
  begin
    insert into foo values (1);
  end;
  /

sql> execute bar();

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

sql> select text from user_source where name='bar';

no rows selected

Question 1: Why did I get the PLS-00553 error? What does it mean? It makes no sense to me. The online documentation on it makes no sense to me either.

Question 2: Why don't I get anything when trying to view the source code of bar? Received on Wed Aug 22 2001 - 15:52:00 CDT