ORA-21700 on initialize object variable through SQL
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..