Executing a stored procedure *How*
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. :
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