Re: Executing a stored procedure *How*

In our last gripping episode "Dim" <species_at_hem2.passagen.se> wrote:
> 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_SS O");
>
> 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
>
>

It would be most helpful to see the code for the procedure.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.