cancel
Showing results for 
Search instead for 
Did you mean: 

call procedure exceptions

Former Member
0 Kudos

I made a rfc-procedure scenario。When it ran an error occured with folowing message ’Error when executing statement for table/stored proc. 'ZRPOPUR' (structure 'Statement'): java.lang.NumberFormatException: High-order nibble of the byte at array offset 277 is not valid. Byte value: 40'。

The procedure input parameters is:

PXFRDT -- DEC(8,0) INPUT

PXTODT -- DEC(8,0) INPUT

PXYRE1 -- CHAR(15) INPUT

PXCHAT -- CHAR(2) INPUT

PXITGR -- CHAR(3) INPUT

PXSUNO -- CHAR(10) INPUT

PXITNO -- CHAR(34) INPUT

PXBANO -- CHAR(12) INPUT

PXPUSL -- CHAR(2) INPUT

PXPUST -- CHAR(2) INPUT

PXBUYR -- CHAR(10) INPUT

PXRRNL -- DEC(4,0)INPUT IS NOT NULL

The procedure resultset is:

PXSUNO CHAR(10)

PXSUNM CHAR(36)

PXPUSL CHAR(2)

PXPUST CHAR(2)

PXPUDT DEC(8,0)

PXYRE1 CHAR(15)

PXBUYE CHAR(10)

PXBUYN CHAR(10)

PXCURR CHAR(3)

PXPAYE CHAR(10)

PXPUNO CHAR(7)

PXPNLI DEC(3,0)

PXPNLS DEC(3,0)

PXPNSL CHAR(2)

PXPNST CHAR(2)

PXITNO CHAR(34)

PXBANO CHAR(12)

PXSUFI CHAR(30)

PXORQT DEC(10,2)

PXPUUN CHAR(3)

PXPUPR DEC(10,3)

PXCMPF CHAR(1)

PXREPF CHAR(1)

PXSCRF CHAR(1)

PXTEXT CHAR(100)

PXNITN CHAR(34)

PXNBAN CHAR(12)

PXRCVQ DEC(10,2)

PXPUQT DEC(10,2)

PXLUDT DEC(8,0)

and i create all the request and response datatype with type 'char。can anyone tell me what should i do? Thx very much!!!!

Accepted Solutions (0)

Answers (1)

Answers (1)

prateek
Active Contributor
0 Kudos

The problem could be with ur jdbc structure.

Refer this

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards,

Prateek