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.