Skip to Content
0
Former Member
Apr 01, 2008 at 09:46 PM

UPDATE_INSERT Error

198 Views

Hi Experts,

Need urgent help.

Right now i am using UPDATE_INSERT for my Receiver JDBC Adapter. But i am getting error in communication channel monitoring that : *ORA-00933: SQL command not properly ended *

and

in oracle if i am trying to run the below command :

*update_insert ol_account

set user_login_id = 'hetal'

where user_unique_id = '750124783';*

Then i am getting error that invalid comman. Can anyone tell me that y it is happening.

Its bit urgent so please reply soon.

The scema is something like this :

<?xml version="1.0" encoding="UTF-8" ?>

- http://reliant.com/xi/EmailSolicitation">

- <statement>

- <OL_ACCOUNT action="UPDATE_INSERT">

<table>OL_ACCOUNT</table>

- <access>

<USER_UNIQUE_ID>0000294551</USER_UNIQUE_ID>

<CPDB_UPDATE_DATE hasQuot="No">04/01/2008 16:18:24</CPDB_UPDATE_DATE>

</access>

- <key>

<USER_UNIQUE_ID>0000294551</USER_UNIQUE_ID>

</key>

</OL_ACCOUNT>

</statement>

</ns0:Modify_OL_Account>

Thanks in advance.

Regards,

Hetal