# Getting exception while passing List<Long> from hibernate to Stored Procedure

Deeps Mistry

Ranch Hand

Posts: 189

posted 4 years ago

Hi,

I need to pass List<Long> from hibernate to my stored procedure. Below is the code for the same -

Here is my query -

My stored procedure looks like this -

The exception is get is -

Is there something wrong with my stored procedure or the way i am passing the List to my stored procedure?

Thanks.

I need to pass List<Long> from hibernate to my stored procedure. Below is the code for the same -

Here is my query -

My stored procedure looks like this -

The exception is get is -

Is there something wrong with my stored procedure or the way i am passing the List to my stored procedure?

Thanks.

Bogdan Baraila

Ranch Hand

Posts: 43

posted 4 years ago

I think that the problem my be in how you are using the NUMBER data type. If you are using oracle then you should use something like this: NUMBER(p) or INTEGER or LONG (BLOB). Here it is the description of NUMBER. As you can see if it's used like in your function then it will basically expect a list of floats.

The NUMBER datatype

Stores zero, positive, and negative numbers, fixed or floating-point numbers

Fixed-point NUMBER

NUMBER(p,s)

precision p = length of the number in digits

scale s = places after the decimal point, or (for negative scale values) significant places before the decimal point.

Integer NUMBER

NUMBER(p)

This is a fixed-point number with precision p and scale 0. Equivalent to NUMBER(p,0)

Floating-Point NUMBER

NUMBER

floating-point number with decimal precision 38

The NUMBER datatype

Stores zero, positive, and negative numbers, fixed or floating-point numbers

Fixed-point NUMBER

NUMBER(p,s)

precision p = length of the number in digits

scale s = places after the decimal point, or (for negative scale values) significant places before the decimal point.

Integer NUMBER

NUMBER(p)

This is a fixed-point number with precision p and scale 0. Equivalent to NUMBER(p,0)

Floating-Point NUMBER

NUMBER

floating-point number with decimal precision 38