-
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
There Nothing You cannot Do, The problem is HOW.
-
Hi,
The problem is in:
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 ;
I am able to create your package with a different query.
Check if CER_CERTIFICATE_ID is number, FRM_FORM_ID and CER_FORM_ID are same type, etc.
-
I commented out the select statement and still it is giving the same error.
There Nothing You cannot Do, The problem is HOW.
-
declare error_msg as varchar2(1000) and then check.
Vinit
-
Originally posted by sudip
I commented out the select statement and still it is giving the same error.
I don't. What version of Oracle R U using?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|