Hi Oracle team,
Our oracle apex version: Application Express 20.2.0.00.20
DB version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
I am getting below error while execution :
DECLARE
l_multipart apex_web_service.t_multipart_parts;
l_clob CLOB;
BEGIN
l_clob:=apex_web_service.append (
p_multipart => l_multipart,
p_name => 'param1',
p_content_type => 'application/json',
p_body => '{"hello":"world"}' );
dbms_output.put_line(l_clob);
END;
/////
DECLARE
l_multipart apex_web_service.t_multipart_parts;
l_request_blob blob;
l_orig blob;
BEGIN
select orig into l_orig from b_test
where seq=4;
apex_web_service.append (
p_multipart => l_multipart,
p_name => 'attachment',
p_content_type => 'application/octet-stream',
p_body_body =>l_orig );
l_request_blob := apex_web_service.generate_request_body (
p_multipart => l_multipart );
dbms_output.put_line(1);
END;
Error report -
ORA-06550: line 5, column 30:
PLS-00302: component 'APPEND' must be declared
ORA-06550: line 5, column 5:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
Please let me know what mistake I am doing in the code ?
Regards,
Ritu