Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid identifier error but the column is valid,

Subhadeep RoyMay 14 2015 — edited May 15 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2015
Added on May 14 2015
6 comments
1,139 views