ORA-01756: quoted string not properly terminated even when use q'[]'

Hi,

I'm facing problem when passing a huge string, e.g. oracle package syntax, I'm passing this syntax to a procedure, so the syntax will be inserted then.

could you please help, how can I pass such string

begin         dbexec.add_parsed_task(p_job_id      => 'DBJ000000000091',         p_script_seq  => 2,         p_task        => q'[CREATE OR REPLACE PACKAGE BODY S2619.Analyze_PackAS   --*********************************************   PROCEDURE analyze (pSchema_Name IN VARCHAR2 DEFAULT NULL, pTable_name IN VARCHAR2, pMandant IN number default null, pDAX IN number default null, pCod_Slot IN VARCHAR2 default null, pTDat_Stichtag IN Date default null)   -- this procedure analyzes only the own schema   IS      v_current_schema   VARCHAR2 (60 CHAR);      v_table_owner      VARCHAR2 (60 CHAR);      v_table_name       VARCHAR2 (60 CHAR);      v_stmt             VARCHAR2 (32000);      v_part_name       varchar2(100 char);      v_part_type       varchar2(20 char);      v_subpart_name    varchar2(100 char);      v_subpart_type    varchar2(20 char);      v_cnt_special_tab   pls_integer;      v_confirmed       boolean;         BEGIN      v_current_schema := SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA');      v_confirmed:=false;      --inf_utility.Trace(pStep => 'ANALYZE', pSchema => v_current_schema,