Execute ORACLE store procedure with input and output parameters.

[Former Member]

Hi everybody,

We have a scenario connecting Oracle DB thru JDBC adapter.

We have to call store procedure with input parameter and output parameter to retrieve data from DB.

I tried to retrieve data with SELECT statement and it works fine. I need to call store procedure in ORACLE instead of SELECT statement.

I am looking for an example.

Thanks in advance,

Gigi

[Former Member]

Hi,

Following will help you http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/basic/plsqlSample/PLSQLSample...

Regards

Ayyapparaj