How to call a stored procedure using its package name in Oracle

[Former Member]

hi

we're doing a JDBC scenario where we call a stored procedure(a.prc) using its package name(b)The stored procedure has In /Out/IN-OUT parameter.

i have got 2 queries:

1- How to call the stored procedure using it's package.

2- How to capture the In/Out parameter in the response.

[prateek · Accepted solution]

Check my reply here

Regards,

Prateek

[Former Member · Accepted solution]

hi Prateek

thanks for the reply.

However when i tried mapping it to Package.procedure, communication channel throws the error saying that Package.proceudre needs to be declared.

As i said , the procedure has IN-OUT parameter too.In oracle we need to write a block if we want to read the IN-OUT parameter.

How to get the IN-OUT parameter in XI?