CREATE OR REPLACE PROCEDURE TASK_INSERT_PROC( PV_PROCESSID VARCHAR2) AS BEGIN INSERT INTO TASK_TEMP (TASKID, TXREFNO, PROCESSID) SELECT statuscode, TXREFNO, PROCESSID FROM ftdmaster WHERE PROCESSID = PV_PROCESSID AND statuscode = '7';
COMMIT;
END TASK_INSERT_PROC;
---------Getting below Error for above code------- Error starting at line : 13 in command - declare v_processid varchar2:='ET06'; begin TASK_INSERT_PROC(v_processid); end; Error report - ORA-06550: line 2, column 13: PLS-00215: String length constraints must be in range (1 .. 32767) 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error. *Action: