Multiple Update issue

[akarsh]

Hi,

I am trying to update a ORACLE table using oracle connector in DS 8.7 through before and after job SQL.
It worked for me once but if i change the value for doing Unit testing its not giving proper results.
Please advise what needs to be done in such case.

[SURA]

What you tried? share the code.

[akarsh]

In Before SQL just giving as

UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;

Same query is working in DB but not updating through DS.

[ArndW]

UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;

What are you actually using as the "Table name" value?

[akarsh]

It's actual oracle DB table name which i need to update.

[ArndW]

in that case, did you include the schema name?

[akarsh]

in that case, did you include the schema name? ...

Yes..

[ArndW]

What is your error message?

[akarsh]

There was no error msg. It was some DB connection issue.

Its resolved now. Thnaks for your help.

[chulett]

Any chance you can elaborate on what "some DB connection issue" means?

It will help future searchers...

[akarsh]

Actually what happend i was using sqldeveloper to access Oracle DB.

When i was updating records for unit testing i was doing commit but it was not working then i used commit option given in sqldeveloper which worked.

After that when i ran before and after SQL it worked perfect for me.
So basically it was commit statement which was not working and causing to not update DB for unit testing. It was not related to DS.