Home -> Usenet -> comp.databases.oracle -> Executing a stored procedure *How*

Executing a stored procedure *How*

From: Dim <species_at_hem2.passagen.se>
Date: Fri, 10 Nov 2000 10:35:21 +0100
Message-ID: <8ugfff$6dt1_at_pen6.pen.k12.va.us> 






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,


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");





OracleCallableStatement cstmt1 =(OracleCallableStatement)conn.prepareCall


("begin portal30_sso.wwsso_ls_private.ls_change_password (?,?,?,?); end;");




 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












Original text of this message