Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Arrow Unanswered: oracle error no ORA-06550,PLS-00553...

    hi

    i will be pleased if u correct this plz..

    The following prg gives error and does not bring any output ...
    (i have give all the pgms which i have tried out !!!!)

    SQL> set serveroutput off

    SQL> DECLARE
    2 vdeptno number(2);
    3 vloc varchar2(15);
    4 BEGIN
    5 select to_number(deptno) ,loc into vdeptno,vloc from dept where dname='SALES';
    6 END;
    7 /

    PL/SQL procedure successfully completed.

    SQL> set serveroutput on

    SQL> /
    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> begin
    2 dbms_output.put_line('sample prg');
    3 end;
    4 /
    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
    Last edited by bharathiraja.s; 11-08-03 at 03:00.

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: oracle error no ORA-06550,PLS-00553...

    Originally posted by bharathiraja.s
    hi

    i will be pleased if u correct this plz
    SQL> DECLARE
    2 vdeptno number(2);
    3 vloc varchar2(15);
    4 BEGIN
    5 select deptno ,loc into vdeptno,vloc from dept where dname='SALES';
    6 END;
    7 /
    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
    Try

    SQL> DECLARE
    2 vdeptno number(2);
    3 vloc varchar2(15);
    4 BEGIN
    5 select to_number(deptno) ,loc into vdeptno,vloc from dept where dname='SALES';
    6 END;
    7 /

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •