Question
Bank Of America
US
Last activity: 31 Aug 2021 4:48 EDT
How to call Oracle package from RDB calls?
Hi,
I want to make a call to Oracle package through Connect-SQL in pega. Is it possible to call package and if yes, then what should be the right format for it?
Below is the query i tried but didn't work.
EXEC PGEPICDATAOWNER.dbMntCCSE.purgeTabData ('TABLE_NAME')
"SchemaOwner.PackageName.Procedure"
@SaurabhG7566You can try below pattern.
\{call DATA.SAMPLE({OperatorID.TestID}, {OperatorID.TestName}) \}
https://collaborate.pega.com/question/how-call-stored-procedure