oracle and stored procedures returning

hi,

i have the following stored procedure in oracle:

create or replace procedure test(

    o OUT FLOAT)
 is
 begin

    o := 9.9;
 end test;

when i call it in jsp i get the following error:

    ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1

my jsp code is as follows:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:Sput", "","");

	CallableStatement cstm = con.prepareCall("{call test(?)}");
	cstm.registerOutParameter(1,java.sql.Types.FLOAT);
	cstm.execute();

does anyone know what i am doing wrong????

Thank You,
Bryna

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 15:46:13 CDT