Oracle Package not executing 1

[NuniPR]

Hi Guys!

I have a package with 7 procedures. I have run these procedures separately and they work perfectly. Now I have assembled all into 1 package and I can't get the packate to run. I get this error:

ORA-06550: line 2, column 16:
PLS-00302: component 'PKG_E911' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

I am running this package in TOAD because I am working on my test environment before running it in production. I notice that when trying to run it, the Set Parameters window has the following script:

BEGIN 
  schema.PKG_INFO.SP_INFO_DEL_REC;
  COMMIT; 
END;

SP_INFO_DEL_REC is the second procedure within the package. Enough said, This is what my package looks like:

CREATE OR REPLACE PACKAGE PKG_INFO AS

PROCEDURE SP_INFO_EXTRACT;

PROCEDURE SP_INFO_DEL_REC;

PROCEDURE SP_SNAP_TRUNC;

PROCEDURE SP_INFO_SNAPSHOT;

PROCEDURE SP_INFO_LOAD_DATA;

PROCEDURE SP_INFO_UPDATE_NAME;

PROCEDURE SP_INFO_UPDATE_ADDRESS;

END;
/

What I am missing?

Thanks so much for your help, guys! You are the best!



Nunina
Cognos BI Administrator
San Juan, PR

 

[NuniPR]

Thanks for all your input. I think that I will approach this using non-packaged, user-defined procedures from the command script as you suggested. My concern was that the executions might be parallel, thus rendering incorrect results.

I will post back the results of my little project in a few days.

Gracias. Aqui va otra estrella!

Nunina
Cognos BI Administrator
San Juan, PR