Error execution

From: Poosapati Varma <psgkv_at_yahoo.com>
Date: Thu, 19 Oct 2000 15:19:27 -0700 (PDT)
Message-Id: <10654.119817@fatcity.com>

Hi guys when i try to compile the following package its compiled without errors.
but when i executed the procedure by
exec <procedure_name>
i get the following error message

SQL> exec sp_ai_gettablename();
BEGIN sp_ai_gettablename(); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SP_AI_GETTABLENAME' must be declared
ORA-06550: line 1, column 7:

the package header & body are

CREATE OR REPLACE PACKAGE TABLES_NAME_PACK AS

TYPE TBLRECID IS TABLE OF NUMBER(10) INDEX BY BINARY_INTEGER;
TYPE TBLNAME IS TABLE OF VARCHAR2(16) INDEX BY BINARY_INTEGER; PROCEDURE sp_ai_GetTableNames(
O_tblrecid OUT TBLRECID,
O_tablename OUT TBLNAME);

END TABLES_NAME_PACK; CREATE OR REPLACE PACKAGE BODY TABLES_NAME_PACK AS

PROCEDURE sp_ai_GetTableNames(
o_tblrecid out tblrecid,
o_tablename out tblname)
is

cursor c2 is

   select recid,table_name from tc_tang_tables;

 reccount_2 number default 0;
BEGIN
  FOR tnamrec IN c2 LOOP
   reccount_2:= reccount_2 + 1;
   o_tblrecid(reccount_2):= tnamrec.recid;    o_tablename(reccount_2):= tnamrec.table_name;   END LOOP;
END sp_ai_gettablenames;

END tables_name_pack;

Can anyone tell me why is this happening?

Varma Poosapati.

---

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. Received on Thu Oct 19 2000 - 17:19:27 CDT