Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: ORA-06553: - What a weird problem

    Hi

    I have created a few procedure in order to denormalise parts of the database. It worked for all of the tables but for a table called trans_ins. I have pasted the shortened Code and the error message below. I don't understand why there can be an error. If I execute the SQL statement 'Select max(trans_ins_id) from trans_ins;' everything is working fine and the DBMS supplies me with the correct result.

    I hope someone can help me.

    Thanks

    SQL> DECLARE
    2
    3
    4 myrown NUMBER(10);
    5
    6 BEGIN
    7
    8
    9 SELECT max(trans_ins_id) INTO myrown FROM trans_ins;
    10
    11
    12 END;
    13 /
    SELECT max(trans_ins_id) INTO myrown FROM trans_ins;
    *
    ERROR at line 9:
    ORA-06550: line 9, column 43:
    PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-320: the declaration of the type of this expression is
    incomplete or malformed
    ORA-06550: line 9, column 1:
    PL/SQL: SQL Statement ignored


    SQL> desc trans_ins
    Name Null? Type
    ----------------------------------------- -------- --------------------------
    TRANSORG NOT NULL NUMBER(10)
    TRANSNEW NOT NULL NUMBER(10)
    TIMEDIFF NUMBER(2)
    TRANS_INS_ID NUMBER(10)
    ORG_ROUTE VARCHAR2(4)
    NEW_ROUTE VARCHAR2(4)
    ORG_STAGE NUMBER(2)
    NEW_STAGE NUMBER(2)
    NEW_DIRECTION NUMBER(1)
    ORG_DIRECTION NUMBER(1)
    DATE DATE
    TRANSID NUMBER(10)

  2. #2
    Join Date
    Sep 2003
    Posts
    3

    SOLVED

    Sorry guys...I solved the problem...

    Had an attribute decalred as Date which is a reserved word...

    Thanks anyway...

Posting Permissions

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