EBS Customizations (MOSC)

MOSC Banner

Pass the record type parameter using pl/sql in the package

edited Jul 15, 2019 5:00AM in EBS Customizations (MOSC) 2 commentsAnswered

I have a package in below in which I have used the record type now I want to test this package using a pl/sql block when I pass the value it errors out, can you guys help on how to test this package

spec of package

OR REPLACE PACKAGE APPS.xxace_ap_cms


AS


xx_invoice_rec_test is record

p_invoice_type           VARCHAR2(30)

p_invoice_number         VARCHAR2(30)



xx_invoice_tbl_test is table of xx_invoice_rec_test INDEX BY BINARY_INTEGER;

xxace_ap


in xx_invoice_tbl_test


p_out_success_1                  out VARCHAR2


p_out_failure_2                  out

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