error while Executing stored procedure ,Help

[2004 IR Help]

By: bhaskar - bhaskar01

error while Executing stored procedure ,Help

2005-02-07 20:57

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.

 

 

 

 

 

By: Peter Severin - peter_p_s

RE: error while Executing stored procedure ,H

2005-02-08 03:29

Hi,

 

A stored procedure specified in the report query must satisfy several constraints. It must return a result set and must not have OUT parameters. If this is too limiting for you, then you can always call the procedure yourself in Java code and then use the ResultSetDataSource or your custom data source.

 

In JasperAssistant you can integrate this logic by implementing a data source provider. For more information on this please see:

 

http://www.jasperassistant.com/docs/guide/ch03s03.html#N10357

 

I hope this helps,

 

Peter Severin

http://www.jasperassistant.com

JasperAssistant - report designer for JasperReports

 

 

 

 

 

By: bhaskar - bhaskar01

RE: error while Executing stored procedure ,Help

2005-02-10 04:35

Hi,

 

how could i get resultset without out parameters. can i use IN OUT parameters in stored proc. still i couldn't resolved.

 

could u please tell me the steps i need to follow to call the stored proc.

 

please help me out with.

 

if u have any samples relating with stored proc. please mail to us balabhaskar_k@yahoo.com or kbbhaskar@rediffmail.com

 

thanks

 

bhaskar.