Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

strange error..PLS-00201: identifier 'PLITBLM' must be declared

BugsFeb 9 2007 — edited Feb 9 2007
SQL>   1  DECLARE
  2   TYPE CUSTOMER_RECORD IS RECORD (CUSTOMER_ACCT_ID NUMBER,
  3                                                       CUSTOMER_NAME   VARCHAR2(2000));
  4  --CREATE TABLE OF RECORD TYPE
  5    TYPE CUSTOMER_REC IS TABLE OF
  6    CUSTOMER_RECORD
  7   INDEX BY BINARY_INTEGER;
  8  --INSTANCE OF RECORD
  9  LREC_CUSTOMER_RECORD CUSTOMER_RECORD;
 10  --INSTANCE OF TABLE
 11  LT_CUSTOMER_REC CUSTOMER_REC;
 12   BEGIN
 13  --ASSIGN VALUES TO INSTANCE OF RECORD
 14   LREC_CUSTOMER_RECORD.CUSTOMER_ACCT_ID:=10;
 15   LREC_CUSTOMER_RECORD.CUSTOMER_NAME:='BHAGAT';
 16  --INSERT INTO TABLE, VALUES FROM RECORD INSTANCE
 17   LT_CUSTOMER_REC(1):=LREC_CUSTOMER_RECORD;
 18  --OUTPUT
 19   DBMS_OUTPUT.PUT_LINE(LT_CUSTOMER_REC(1).CUSTOMER_ACCT_ID);
 20   DBMS_OUTPUT.PUT_LINE(LT_CUSTOMER_REC(1).CUSTOMER_NAME);
 21*  END;
 22  /
*
ERROR at line 1:
ORA-06550: line 0, column 0:
PLS-00201: identifier 'PLITBLM' must be declared
ORA-06550: line 0, column 0:
PLS-00201: identifier 'PLITBLM' must be declared

Could someone help me out with this error?
Thanks,
Bhagat

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2007
Added on Feb 9 2007
4 comments
1,812 views