Results 1 to 5 of 5

Thread: Pls-00553

  1. #1
    Join Date
    Mar 2004
    Posts
    17

    Unanswered: Pls-00553

    Hi,

    I am trying to run this sample code on Oracle 8i.

    DECLARE
    MY_EXCEPTION EXCEPTION;
    BEGIN
    DBMS_OUTPUT.PUT_LINE('START OUTER BLOCK BEGINS');

    DECLARE
    MY_EXCEPTION1 EXCEPTION;
    BEGIN
    DBMS_OUTPUT.PUT_LINE('INNER BLOCK BEGINS');
    RAISE MY_EXCEPTION1;
    EXCEPTION
    WHEN MY_EXCEPTION1 THEN
    DBMS_OUTPUT.PUT_LINE('IN MY EXCEPTION1');
    END;

    RAISE MY_EXCEPTION;

    EXCEPTION
    WHEN MY_EXCEPTION THEN
    DBMS_OUTPUT.PUT_LINE('IN MY EXCEPTION');
    WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('ANY EXCEPTION');
    END;

    But it gives me the following error message :

    ERROR:
    ORA-06550: line 1, column 29:
    PLS-00553: character set name is not recog
    ORA-06550: line 0, column 0:
    PL/SQL: Compilation unit analysis terminat

    Can someone pls. throw some light.
    I have had a look at the NLS paramaters set for the database and at the session level. They seem to be OK

    rgds
    Cyberbob

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    No idea, Cyberbob ... I ran the script on Ora 7.3, 8.1.7, 9 and on all of them there were no errors at all ...

  3. #3
    Join Date
    Mar 2004
    Posts
    17
    Thats the reason why I am puzzled as well
    Anyways thanks for the efforts

  4. #4
    Join Date
    Mar 2004
    Posts
    17
    Even this doesnt work

    BEGIN
    DBMS_OUTPUT.PUT_LINE('1');
    END;


    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



    PL/SQL procedure successfully completed.

  5. #5
    Join Date
    Mar 2004
    Posts
    17
    I restarted Oracle and this is working now!!!
    Don know what happened.

    Thanks
    Cyberbob

Posting Permissions

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