waiting for 12C version
Javier Torijano, July 24, 2017 - 6:11 am UTC
Hello, thanks for your answer, I hope that we can do it with 12c Versin.
In the other hand I tried before with objects and we obtain the same result.
create or replace TYPE blk_esta_object as object (
codi_mone VARCHAR2(1),
codi_situ VARCHAR2(1),
situ_pig VARCHAR2(1),
IMPORTE NUMBER(11,2)
);
/
declare
bloq_esta blk_esta_object;
name varchar2(150) := 'codi_mone';
sentencia varchar2(2000);
begin
sentencia:='select ''E'' into bloq_esta.'|| name ||' from dual';
execute immediate(sentencia);
end;
output: Error report -
ORA-00905: missing keyword
ORA-06512: at line 9
00905. 00000 - "missing keyword"