Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OIC atp can't invoke proc with %rowtype parameter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OIC atp can't invoke proc with %rowtype parameter

Question
10
Views
0
Comments
edited Feb 18, 2021 4:04PM in Integration

Summary

OIC atp can't invoke proc with %rowtype parameter

Content

I am trying to add an ATP database node to my OIC integration.  I go through the wizard and select "Invoke a stored procedure", specify the schema, the package, and the procedure, but when I get to the last step and select "Done", it gives me the error shown below.  The PSP_WORKORDERS table has many columns, so I don't want to have to list each one in the parameter list.

The procedure looks like this:

PROCEDURE insert_row_wo (
    fr_wo          IN       psp_workorders%ROWTYPE,
    fn_wo_id       OUT      PLS_INTEGER,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!