79221760

Date: 2024-11-25 05:51:47
Score: 1
Natty:
Report link

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:

Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Filler text (0.5): ---------
  • Low reputation (1):
Posted by: bharath