- ORDS.DEFINE_HANDLER(
-
p_module_name => 'EMRPRJWSTV1.0', -
p_pattern => 'getPriceConfigDetails', -
p_method => 'GET', -
p_source_type => 'plsql/block', -
p_mimes_allowed => NULL, -
p_comments => NULL, -
p_source =>
9.'DECLARE 10. o_json_clob CLOB; 11. v_appname VARCHAR2(1000); 15.BEGIN 16. apps.XXOM_PRJWS_API_PKG.get_price_config_details(i_json_clob => :body_text, o_json_clob => o_json_clob);
- CREATE OR REPLACE PACKAGE BODY APPS.xxom_prjws_api_pkg 20.is
- PROCEDURE get_price_config_details(i_json_clob CLOB,
-
o_json_clob OUT CLOB) - is
24.dbms_lob.append(o_json_clob,to_clob('"item_type_code":"'|| l_line_rec_tbl(j).item_type_code||'",'));
25.dbms_lob.append(o_json_clob,to_clob('"line_number":"'|| l_line_rec_tbl(j).line_number||'",'));
I am calling above procedure from Python/Postman to get the value of o_json_clob, when the size is less than or equal to around 32767 then it is working fine but when size of o_json_clob is going more than 32767 then PL/SQL Procedure throws an error.
However same procedure works fine when called from Oracle SQL Developer. So how do I get value of this clob variable if the size is more than 32767 characters.