Executing a stored procedure *How*

[Quoted] I have Oracle 816 installed and running, Also Oracle Portal 30.

I want to be able to change password for Portal users, using a remote application.
I connect to database via JDBC and there's a stored procedure which can do the job,
[Quoted] but I have some difficulties executing it. Heres the code I use. :

PL/SQL: DECLARE
    out_var NUMBER;
BEGIN
    portal30_sso.wwsso_ls_private.ls_change_password     ('domino','ergoforce5','devil888',out_var); END;
/

Java:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:_at_consult:1521:surijama", "PORTAL30_SSO", "PORTAL30_SSO");

[Quoted] OracleCallableStatement cstmt1 =(OracleCallableStatement)conn.prepareCall
[Quoted] ("begin portal30_sso.wwsso_ls_private.ls_change_password (?,?,?,?); end;");

[Quoted]  cstmt1.setString(1, "DOMINO");    //ssousername.
 cstmt1.setString(2, "ergoforce5");    //oldpwd
 cstmt1.setString(3, "mode555");    //newpwd
 cstmt1.registerOutParameter(4, OracleTypes.NUMBER );

 cstmt1.execute ();
 cstmt1.close();

Both ways give me an error ORA-06502 numeric or value error. What am I doing wrong?
I'd appreciate any help
Thanks
Dmitriy Received on Fri Nov 10 2000 - 10:35:21 CET