call SP from EJB - error: Data size is bigger than ...

Hi all,

I am trying to call a stored procedures within an EJB by using the CallableStatement. The stored procedures has one 'in' and one 'out' parameter (both varchar2). By binding a String value to the 'in' parameter using .setString() the program throws a SQLException saying 'Data size is bigger than max. size of type: 9080'. 9080 is the size of my String. I am using ORACLE 7.

Is it a driver problem? Do I have to use another binding type? Is there a way around by using LONG and how can I do this from Java?

Thanks for any help.
Joerg Received on Tue Mar 14 2000 - 03:04:25 CST