unable to execute the block

unable to execute the block

Oct 18 '22 Comments: 1 Answers: 0

0

can you help me in rectifying the following code

execute immediate $$
declare
    TABLE_CATALOG varchar default ('DB')
    TABLE_SCHEMA varchar default ('SCH');
    VIEW_NAME varchar default ('View');
  VEW resultset default (SELECT * from table(GET_OBJECT_REFERENCES(DATABASE_NAME =>:TABLE_CATALOG , SCHEMA_NAME =>:TABLE_SCHEMA, OBJECT_NAME =>:VIEW_NAME)));
 begin
return table(VEW);
end;
$$
;

the following error appears when the…

Open Full Question