Tweet
Hi Folks,
I'm posting transmissions to OTM directly from an Oracle database using UTL_HTTP. The problem is that I need to get an acknowledgment from OTM that the record was received and processed, but I can't receive the ack from OTM, because I'm not an app server, just a database. So I guess my question is, is there a way I can request an ack from OTM, so that I can use UTL_HTTP to pull the ack rather than have OTM push it to me.
I've got a simple Appication Express front end that we're using to push records into OTM, but I need to figure out a way to get the acknowledgements back, essentially. I'm trying to avoid java, as the front end all Application Express / PL/SQL.
Thanks for any insight,
-Adam
I'm posting transmissions to OTM directly from an Oracle database using UTL_HTTP. The problem is that I need to get an acknowledgment from OTM that the record was received and processed, but I can't receive the ack from OTM, because I'm not an app server, just a database. So I guess my question is, is there a way I can request an ack from OTM, so that I can use UTL_HTTP to pull the ack rather than have OTM push it to me.
I've got a simple Appication Express front end that we're using to push records into OTM, but I need to figure out a way to get the acknowledgements back, essentially. I'm trying to avoid java, as the front end all Application Express / PL/SQL.
Thanks for any insight,
-Adam