Jump to content
Changes to the Jaspersoft community edition download ×

Error While executing Stored Proc in Jasper


2004 IR Help

Recommended Posts

By: bhaskar - bhaskar01

Error While executing Stored Proc in Jasper

2005-02-07 06:52

All,

 

i'm facing the prob while calling stored procedure from jasper assistant(Trail Version). please help me regarding this.

and i ve done all permutation and combinations as earlier done by others but it not works. i could not able to detect the error in my code is as follows.

Error: Unable to get next record,

Caused by: ORA-00600:internal error code, arguments:[122259],[],[],[],[],[],[]

 

 

I ve set property Query in report section with

++++++++++++++++++++++++++

{call myprocs($P{PRJ_NME},$P{TRGT_CURR_OUT})}

++++++++++++++++++++++++++

exec myprocs $P{PRJ_NME},$P{TRGT_CURR_OUT}

***************************

CREATE PROCEDURE Myprocs

(PRJ_NME IN VARCHAR2,

TRGT_CURR_OUT OUT NUMBER)

AS

--PRJ_NME VARCHAR2(60);

trgt_curr_local NUMBER(19,2);

 

BEGIN

--PRJ_NME:='Project1';

DBMS_OUTPUT.PUT_LINE('PROCESS START HERE ::' || PRJ_NME);

 

SELECT YRLY_TRGT_AMT

INTO trgt_curr_local

FROM FRCST_YR

WHERE YR_NME=TO_CHAR(SYSDATE,'yyyy')

AND ACTL_FRCST_INDCR_CD='F'

AND PROJ_NME=PRJ_NME;

 

TRGT_CURR_OUT := trgt_curr_local;

 

DBMS_OUTPUT.PUT_LINE('YEARLY FOR CURR :: ' || TRGT_CURR_OUT);

 

--SELECT YRLY_TRGT_AMT

--INTO TRGT_FIRST_OUT

--FROM FRCST_YR

--WHERE YR_NME=TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'yyyy'))+1)

--AND PROJ_NME=PRJ_NME

--AND ACTL_FRCST_INDCR_CD='F';

 

--DBMS_OUTPUT.PUT_LINE('YEARLY FOR FIRST :: ' + TRGT_FIRST_OUT);

 

--SELECT YRLY_TRGT_AMT

--INTO TRGT_SEC_OUT

--FROM FRCST_YR

--WHERE YR_NME=TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'yyyy'))+2)

--AND PROJ_NME=PRJ_NME

--AND ACTL_FRCST_INDCR_CD='F';

 

--DBMS_OUTPUT.PUT_LINE('YEARLY FOR SEC :: ' + TRGT_SEC_OUT);

 

EXCEPTION

WHEN NO_DATA_FOUND THEN

DBMS_OUTPUT.PUT_LINE('NO DATA FOUND ::' || PRJ_NME);

TRGT_CURR_OUT := 0;

--NULL;

WHEN OTHERS THEN

-- Consider logging the error and then re-raise

RAISE;

END Myprocs;

/

*************************************

any earliest help will greatful to me.

 

regards,

 

bhaskar.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...