Originally posted by: SystemAdmin

I am trying to use an Oracle stored procedure as input, but I'm having trouble getting the query right in Interface designer. I'm hoping someone can help.

Systems:
Oracle 9i
DSTX 7.5.1

The Oracle proc returns a cursor, but I get an error when I try to call the proc with just the cursor as an argument:
begin CCIT.TBILLPRN_DATA_PKG.LSP_SELECT_FROM_TBILLPRN('TBILLPRN_CURSOR');end;

I've tried reading the documentation, but I'm not getting how the call should work. Do I need to create the type tree fields for each column and pass those to the procedure, even though the cursor is a pointer to the four columns?

I.E. * This is pseudo code for the actual Oracle proc, I'm not developing that piece *
Create Proc MyProc(
Cursor MyCursor IS
Select ColA,
ColB,
ColC,
ColD,)

Then in the DID query, is the syntax:
begin MyProc('MyCursor');end;

or is it
beging MyProc('ColA','ColB','ColC','ColD') ?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange