Hi! All,
I am creating the following package and it is giving me this wierd error as listed below. I am commented out the code and replaced it with a single statement NULL;. Even then the same error is occuring.
Thanx in advance
Sudip
CREATE OR REPLACE PACKAGE BOP_STES AS
TYPE RESULTSET_CURSOR IS REF CURSOR;
PROCEDURE SP_RETRIVE_FORM_DATA
(p_certificate_id NUMBER,
ERROR_MSG OUT VARCHAR2,
THE_RESULTS IN OUT RESULTSET_CURSOR);
END BOP_STES;
/
CREATE OR REPLACE PACKAGE BODY BOP_STES AS
PROCEDURE SP_RETRIVE_FORM_DATA
(p_certificate_id NUMBER,
ERROR_MSG OUT VARCHAR2,
THE_RESULTS IN OUT RESULTSET_CURSOR) IS
BEGIN
OPEN THE_RESULTS FOR
SELECT
FRM_FORM_ID, FRM_FORM_NAME,
FRM_IMAGE_NAME, FRM_FILE_NAME,
FRM_PATH
FROM TBL_BOP_FORM_TEMPLATE FRM,
TBL_BOP_CERTIFICATE CER
WHERE FRM_FORM_ID = CER_FORM_ID
AND CER_CERTIFICATE_ID = p_certificate_id ;
ERROR_MSG := 'SUCCESS';
EXCEPTION
WHEN NO_DATA_FOUND THEN ERROR_MSG := SQLERRM;
WHEN OTHERS THEN ERROR_MSG := SQLERRM;
END;
END;
/
CREATE OR REPLACE PACKAGE BODY BOP_STES AS
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01401: inserted value too large for column
ORA-06512: at line 27