PL/SQL (MOSC)

MOSC Banner

ORA-21700 on initialize object variable through SQL

edited Sep 23, 2020 9:29AM in PL/SQL (MOSC) 3 commentsAnswered

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0

CREATE OR REPLACE TYPE AIS.T_BASE_REC FORCE AS OBJECT (ISN NUMBER) NOT FINAL

declare

  o  AIS.T_BASE_REC;

begin

  select AIS.T_BASE_REC(ISN => 1) into o from dual;

end;

Get ORA-21700: object does not exist or is marked for delete.

o := AIS.T_BASE_REC(ISN => 1);  working fine.

The same code does not lead to an error on another database.

PS

This is a simplified example, the full more complex SQL and uses bulk collect into..

Tagged:

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