PL/SQL (MOSC)

MOSC Banner

Passing Table as input Parm for Debugging

edited Jan 30, 2012 3:20AM in PL/SQL (MOSC) 2 comments
How does one, when starting a debug session, pass a table as an input parm? For arguments sake, assume there are 4 entries to the table.

I would like to step through the procedure in Debug and need the p_address_list.

Parms to procedure look like:

   PROCEDURE derive_ship_to(
                                p_customer_id       IN      NUMBER,
                                p_org_id            IN      NUMBER,
                                p_address_list      IN      XX01_ORD_ADDRESS_TBL,
                                x_ship_to           OUT     NUMBER)

Given the the passed table is based on:

create or replace
TYPE XX01_ORD_ADDRESS_OBJ AS OBJECT
( Description  VARCHAR2(150),
  Qualifier  VARCHAR2(150),
  ID_Code  VARCHAR2(150),
  Location_Code  VARCHAR2(150),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center