Oracle Return TYPE Package

[Former Member]

Hi,

I have a oracle scenario in which the oracle returns a package.

create or replace PROCEDURE sp_biz_update (

loading IN NUMBER,

cursor OUT pkg_biztalk.order,

item OUT pkg_biztalk.item,

item1 OUT pkg_biztalk.item1

Is it possible to call this procedure in this way? How should I define the structure???

[kenny_scott · Accepted solution]

Hi Chris,

did you intend this thread to be created in the XI/PI forum?

If yes can you please provide more information to help explain the scenario?

Regards

Kenny

[Former Member · Accepted solution]

These are CURSOR's. I didn't know if cursors where supported or not. They are supported

Thanks.