im getting error while trying convert clob varchar2 using api. the 'body' field im trying retrieve clob, want convert varchar2(1000). please advice why error occurred : merge xxx d using ( select v_ticket_id ticket_id, json_ext.get_number(json(value(s)),'id') comment_id, json_ext.get_number(json(value(s)),'author_id') author_id , dbms_lob.substr(json_ext.get_string(json(value(s)),'body'),1000,1) body, json_ext.get_string(json(value(s)),'via.channel')channel, case when lower(json(value(s)).get('public').to_char()) = 'true' 1 else 0 end is_public, to_date(replace(replace(json_ext.get_string(json(value(s)),'created_at'),'t',' '),'z',nul...
Comments
Post a Comment