PL/SQL (MOSC)

MOSC Banner

Is there a chance of raising ORA-0054 for a DML operation such as SELECT .... FOR UPDATE or UPDATE .

edited Dec 24, 2012 10:43PM in PL/SQL (MOSC) 5 commentsAnswered
Hi All,

Is there a chance of throwing ORA-00054 during a DML operation such as SELECT .... FOR UPDATE or UPDATE?

According to the ORA-00054 definition, this exception can only be expected during DDL or SELECT .. FOR UPDATE NOWAIT  operations.

https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=184249924334138&id=18245.1&_afrWindowMode=0&_adf.ctrl-state=1a6l5m6h63_378

But it's 'Diagnosis' section says  "- None normally required unless this is occurring when not expected." 

Does this mean, -00054 exception can be raised elsewhere as well ?????????

Thanks,

Rona

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center