Warehouse Builder: how to pass parameters to mapping-package
From: Jaap W. van Dijk <j.w.vandijk_at_donotspam.kpn.com>
Date: 20 Oct 2003 11:48:37 GMT
Message-ID: <01c39700$18d0b0f0$437315ac_at_HKTGN0002220840>
Hello,
Date: 20 Oct 2003 11:48:37 GMT
Message-ID: <01c39700$18d0b0f0$437315ac_at_HKTGN0002220840>
Hello,
In Oracle Warehouse Builder 9.2, if you create a mapping, a PL/SQL-package is generated with a function MAIN. If you want to execute the package, you have to call the function. But what are the values you have to pass to the IN parameter P_ENV of the function?
So far I have found that the parameter P_ENV is of type TABLE OF RECORD, and this record has two fields, param_name en and param_value.
Can anybody shed some light on this or point me to the location where this is documented?
Jaap. Received on Mon Oct 20 2003 - 13:48:37 CEST