the code which is used to save comment
DECLARE
L_ERROR VARCHAR2(4000);
E_EXCEPTION EXCEPTION;
L_SYSDATE DATE := SYSDATE;
L_RESPONSE VARCHAR2(4000);
l_id NUMBER;
l_role_type_id NUMBER;
l_msg VARCHAR2(2000);
l_error_msg VARCHAR2(1000);
l_response_msg VARCHAR2(1000);
l_sponsor_party_id NUMBER := :P3_SPONSOR_PARTY_ID;
ln_set_context VARCHAR2(20);
BEGIN
ln_set_context := FP_SET_CONTEXT_APPS_PKG.SET_CONTEXT(:G_tOKEN);
IF :P2_COMMENT IS NOT NULL THEN
Test_PKG.ticket_comment (
p_ticket_comment_id => :P2_COMMENT_ID ,
p_ticket_id => :P2_TICKET_ID ,
p_ticket_description => regexp_replace(:P2_COMMENT, '<img[^>]*>?', '') ,
p_cmt_attachment => regexp_substr(:P2_COMMENT, 'data:image/png;base64,([^"]+)', 1, 1, NULL,1) ,
p_token => :g_token ,
p_error => l_Error
);
END IF;
IF L_ERROR IS NOT NULL THEN
RAISE E_EXCEPTION;
END IF;
EXCEPTION
WHEN E_EXCEPTION THEN
RAISE_APPLICATION_ERROR(-20100,L_ERROR );
FP_ERROR_MGR.LOG_ERROR();
WHEN OTHERS THEN
FP_ERROR_MGR.LOG_ERROR();
RAISE_APPLICATION_ERROR(-20150,'Error processing action, Contact System Administrator.'||SQLERRM);
END;
While add the text with image in the comment description it throws the error and i can't able to find the finally entered comment