Dears ,
I am using apex 5.1.4
Oracle xe 11g
i have process in after header point to get the data from Restful services to items .
but i have this error
ORA-20987: Error at line 1, col 1: Unexpected character "<"
Please help
begin
select
x.PRODUCT_ID,
x.PRODUCT_NAME,
x.ACTIVE,
x.BARCODE,
x.CODE,
x.PRICE
into
:P12_PRODUCT_ID,
:P12_PRODUCT_NAME,
:P12_ACTIVE,
:P12_BARCODE,
:P12_CODE ,
:P12_PRICE
from apex_collections c, xmltable(
'/json'
passing apex_json.to_xmltype( c.clob001 )
columns
PRODUCT_ID number path 'product_id',
PRODUCT_NAME VARCHAR2(4000) path 'product_name',
ACTIVE number path 'active',
BARCODE VARCHAR2(4000) path 'barcode',
CODE VARCHAR2(4000) path 'code' ,
PRICE number path 'price'
) x
where c.collection_name = 'REST_COLLECTION';
end;