My Oracle procedure (which works fine when manually invoked) is:
>
> PROCEDURE get_account_email
> (id IN INTEGER, email OUT VARCHAR)
> IS
> BEGIN
> SELECT acc_email
> INTO email
> FROM account2
> where ACC_ID = id;
> END;
>
> -
Hi
Since you're only updating a parameter, I think you should use the update
method for the sqlmap client:
sqlMap.update("getAccountEmailViaProcedure", param);
And then get the updated parameter from the parameter map itself:
String email = (String) param.get("email");
And the parameter "id" s
Hi, all.
I need some help to run a stored procedure with iBATIS. Sorry if this
question has already circulated in list.
When trying to run the procedure, I run into a problem. My database is
Oracle 10g Express Edition and I'm currently using iBATIS 2.0 Beta 4.
This is the output I get when invok
