Execute procedure from a package

Hi,

Am trying to execute a procedure from Package

BEGIN
  POST_LOAD_PKG.WRK_PRG_PST_LD('01-OCT-2015','WRK_PRG_COL');
END;

I have also tried as the below and still the same error
BEGIN
  POST_LOAD_PKG.WRK_PRG_PST_LD(to_date('10/01/2015','mm/dd/yyyy'),'WRK_PRG_COL');
END;


and I get the following error. Am not sure why. This procedure has both in paramaters, one as date and the other as varchar2. Can someone please help me..

BEGIN
  POST_LOAD_PKG.WRK_PRG_PST_LD('01-OCT-2015','WRK_PRG_COL');
END;
Error at line 2
ORA-06550: line 2, column 22:
PLS-00302: component 'WRK_PRG_PST_LD' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
Script Terminated on line 2.
d27m11yAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
'01-OCT-2015'   isn't a date,  it's text,

to_date('01-OCT-2015','dd-MON-yyyy')    is a date

it's likely the text will be implicitly converted to a date though,  it's still MUCH better practice to explicitly convert it yourself though.


for the 302 error,   is your procedure actually a function?  is it declared in the package spec as well as the body?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gerwin Jansen, EE MVETopic Advisor Commented:
If POST_LOAD_PKG.WRK_PRG_PST_LD exists - does the user that you are testing with have access to the procedure/function? If not you need to grant the test user execute rights to the procedure/function.
0
awking00Commented:
Can you post the code for the specifications of the POST_LOAD_PKG and the code for the body of the WRK_PRG_PST_LD function or procedure? There are a number of things that can cause the PLS-00302 error and this might help the experts in determining what a solution should be.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.