Passing Table as input Parm for Debugging
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),