Parameter in Oracle alert
Hi Experts,
I am triggering a concurrent program in a 'Oracle Alert' .This Alert will be triggered when a record is inserted/updated in hz_parties table.The party_id and party_name from hz_parties
is passed as a parameter to the concurrent program.Below is the query used.
SELECT PARTY_ID ,PARTY_NAME INTO &P_PARTY_ID1,
&PARTY_NAME1 FROM HZ_PARTIES
WHERE PARTY_TYPE ='ORGANIZATION'
and CREATED_BY_MODULE = 'CE'
and ROWID=:ROWID
Here is how i am calling the concurrent program.
For ex: If party_name is "Bankalert1" then the concurrent program is working correctly as expected.