Hi,
I'm trying to call a stored procedure from
Java and getting an error while trying to do so.
The stored procedure accepts 1
String parameter as input and outputs 3 parameters as VARCHAR (i.e. String).
I'm able to run the stored procedure separately and it gives the expected result. So, there might not be any issues in the stored procedure. I'm also able to connect to the Oracle database and run a simple select query. The problem only arises while calling a stored procedure.
Here's the code snippet for calling the stored procedure:
Here's the error log:
I'm guessing there might be a problem with the syntax while calling the stored procedure. But, I'm not sure how to fix it.
Any help would be highly appreciated.
Thanks.
-Pushkar