Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot commit DML scripts (DELETE, INSERT, UPDATE) #525

Closed
dnlw07 opened this issue Mar 18, 2020 · 2 comments
Closed

Cannot commit DML scripts (DELETE, INSERT, UPDATE) #525

dnlw07 opened this issue Mar 18, 2020 · 2 comments
Labels

Comments

@dnlw07
Copy link

dnlw07 commented Mar 18, 2020

Describe the bug
When I execute Insert or Delete command then the change is not applied in Oracle DB.
After script execution I use COMMIT to finish transaction.

No errors are returned during script insert, delete, and commit execution.

@dnlw07 dnlw07 added the triage label Mar 18, 2020
@ramonoise
Copy link

I'm also having this problem. When I execute an update/insert/delete query like:

update db.sample_table
        set client_name = 'Example' 
        where id = '1';

It run with success with the message: 1 rows were affected, but the change it's not represented on table. So I run COMMIT in a separated query, and the message is:

No Data

And the table is still with the previous value.
If I run something like:

update db.sample_table
        set client_name = 'Example' 
        where id = '1';
commit;

I get the following message:
ORA-00933: SQL command not properly ended

@mtxr
Copy link
Owner

mtxr commented Aug 21, 2020

Not supported within this repository anymore.

@mtxr mtxr closed this as completed Aug 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants