Hi Xperts,
When I am executing Below select query, it is being executed properly & giving me desired output.
SELECTÂ
sslock.userid , sslock.plantstructureentryid , sslock.audsid
FROM sslock
WHERE sslock.audsid NOT IN ( SELECT audsid FROM v$session );
But whenever I am using same select query as a cursor in a package, then while compiling it is giving "ORA-00904: "audsid": invalid identifier".
The same procedure is running fine in production environment. But in INT end its throwing above error. Could you please tell me what would be the reason & how to overcome it. Database is 11g