-
PLS-00225 error and Packages
Hello,
i have created two packages that i want to both use together.
But if i test my stored proc i have and PLS-00225 error :
"PLS-00225: subprogram or cursor 'LOG' reference is out of scope" on line 146/column 8
here is the line 146 of my stored proc:
EXCEPTION
WHEN UTL_FILE.INVALID_PATH THEN
LOG.errorLog(
'Error Error',
SQLCODE,
'Check your code',
'-20001',
'Check your code');
And this is the stored proc in the LOG package
SPEC :
PROCEDURE errorLog(
title_output VARCHAR2,
sSQLCODE NUMBER,
descr_output VARCHAR2,
raiseCode VARCHAR,
raiseDESC VARCHAR2
);
BODY :
PROCEDURE errorLog(
title_output VARCHAR2,
sSQLCODE NUMBER,
descr_output VARCHAR2,
raiseCode VARCHAR,
raiseDESC VARCHAR2
)
IS
BEGIN
dbms_output.put_line( title_output );
dbms_output.put_line( sSQLCODE || descr_output);
RAISE_APPLICATION_ERROR( raiseCode , raiseDESC);
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END errorLog;
But if i put the stored proc's ownership on the call it works !!!???
example :
EXCEPTION
WHEN UTL_FILE.INVALID_PATH THEN
CRMDVL.LOG.errorLog(
'Error Error',
SQLCODE,
'Check your code',
'-20001',
'Check your code');
In that case it's all good !
Can someone help me for this problem (no owner to indicate on the stored procedure)?
Thanks a lot.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|