on 07-24-2007 3:13 AM
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!!!!
The problem could be with ur jdbc structure.
Refer this
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.