Working on Oracle v8i 22.214.171.124.0 with OS as NT!
P.S:I had tried compiling the package but still things are the same!What is the other alternative to it!
1. We had created a public Synonym HRD_MASTERS for a Package xyz.
This synonym HRD_MASTERS is owned by HRD schema and had granted the privilege from HRD schema as under to all the other schemas:
GRANT EXECUTE ON HRD.HRD_MASTERS to public;
Now except MFG schema all other schemas are able to describe the HRD_MASTERS synonym as under:
Describing HRD_MASTERS throws this error:
ORA:24372:Invalid Object for describe.
This user is just calling one particular Function:
ABC in HRD_MASTERS Package.
This was working fine since this morningtill late afternoon!
Oracle error message occurs:Invalid object.
2.To-day in the afternoon,Sql got disconnected automatically and gave the error:TNS: NO LISTNER.After sometime, sql got connected automatically once again!
What could be the problem!What went wrong!
Thanks & Regards,
Oracle DBA (OCP) v8i,v9i
Click Here to Expand Forum to Full Width