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

laugh_at_starpower.net (Paul Brinkley) wrote in message news:<3b841aec.766911830_at_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?

What version/platform are you on? I was able to run the following code just fine (IBM Dynix 8.1.7) :
UT1> create table foo (fld1 number);

Table created.

UT1>
UT1> create or replace procedure bar
  2 is
  3 begin
  4 insert into foo values (1);
  5 end;
  6 /

Procedure created.

UT1>
UT1> execute bar;

PL/SQL procedure successfully completed.

UT1>
UT1> execute bar();

PL/SQL procedure successfully completed.

• Mark D Powell --