JohnDanter2
VIP Member
Hi folks
Does anyone here use PL SQL and have they called the stored procedures from Orchestrations at all?
We are flirting with the idea of using Orchestrations as a rapid data copy tool from PD down to UT PY etc, but we have a lot of external data linked to orders etc outside of E1
So I would like to use the same orch to enter/copy Non PD data and also find a way to add all this external data at the same time too.
Calling the PL SQL is not enough, I would like to pass in things like where MCU = Variable or AN8 = Variable. This doc says it's doable, but has anyone done this?
Thanks
John
Does anyone here use PL SQL and have they called the stored procedures from Orchestrations at all?
We are flirting with the idea of using Orchestrations as a rapid data copy tool from PD down to UT PY etc, but we have a lot of external data linked to orders etc outside of E1
So I would like to use the same orch to enter/copy Non PD data and also find a way to add all this external data at the same time too.
Calling the PL SQL is not enough, I would like to pass in things like where MCU = Variable or AN8 = Variable. This doc says it's doable, but has anyone done this?
Thanks
John
Last edited: