Ask a Question

ORA-01086: savepoint 'L_SAVEPOINT' never established in this session or is invalid

in Education by
In my case, savepoint was set in Java and I am trying to rollback in a plsql procedure which was called in Java using a callable statement. There are no commits or rollbacks in between, but I am still seeing the error: ORA-01086: savepoint 'L_SAVEPOINT' never established in this session or is invalid Is it because the savepoint is set in Java and I am trying to rollback in plsql? Can someone please help me with this? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
Just throwing some light on this, My colleague experienced the similar issue when he controls the transaction but I had a commit inside the stored procedure. Remove the Commit/Rollback from the SP and you should be all set if you want to control the transaction from Java.

Related questions

0 votes
Q: In Oracle APEX I cannot append data more than 32kb in CLOB
    I have text stored in a database table, many short rows about 70-90 characters long fields. (of ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 2, 2022 in Education by JackTerrance
0 votes
Q: In Oracle APEX I cannot append data more than 32kb in CLOB
    I have text stored in a database table, many short rows about 70-90 characters long fields. (of ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
Q: Error on function in PL/SQL
    I tried to create following function: CREATE OR REPLACE function CATEGORYTEST(n in number) return VARCHAR(200 ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 18, 2022 in Education by JackTerrance
0 votes
Q: Error on function in PL/SQL
    I tried to create following function: CREATE OR REPLACE function CATEGORYTEST(n in number) return VARCHAR(200 ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 17, 2022 in Education by JackTerrance
0 votes
Q: Error on function in PL/SQL
    I tried to create following function: CREATE OR REPLACE function CATEGORYTEST(n in number) return VARCHAR(200 ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 16, 2022 in Education by JackTerrance
0 votes
Q: Explain the SAVEPOINT statement.
    Explain the SAVEPOINT statement....
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
Q: The data type of a column can never be changed once it has been created. True or false?
    The data type of a column can never be changed once it has been created. True or false? Select the correct answer from above options...
asked Nov 29, 2021 in Education by JackTerrance
0 votes
Q: Message: ini_set(): A session is active. You cannot change the session module's ini settings at this time
    I created a login page with codeigniter,but i get the php message. Message: ini_set(): A session ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
Q: Write a program in Java to input any age and determine whether the age is valid or  invalid. If age is greater than or equal to 18 then it is valid otherwise invalid.
    Write a program in Java to input any age and determine whether the age is valid or  invalid. If age is ... is valid otherwise invalid. Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
Q: Why some of my cronjobs were never executed?
    I have the following cronjobs in my crontab: 0 22 * * 1-6 /root/sbin/mysqlbackup --conf-dir=/ ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 3, 2022 in Education by JackTerrance
0 votes
Q: AVPlayerItemDidPlayToEndTime never reaches selector on Swift 3
    I'm adapting my app to Swift 3 and I'm encountering this problem. This used to work on Swift 2. ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
Q: Custom intent is being confirmed over and over again, and never handled
    I've inherited a codebase that implements a half-baked implementation of custom intents and shortcuts. One ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 21, 2022 in Education by JackTerrance
0 votes
Q: What are the dark corners of Vim your mom never told you about? [closed]
    As it currently stands, this question is not a good fit for our Q&A format. We expect answers to ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 27, 2022 in Education by JackTerrance
0 votes
Q: 8. YOU CAN NEVER STORE 2FILES OF THE SAME NAME IN
    8. YOU CAN NEVER STORE 2 FILES OF THE SAME NAME IN THE SAME________ Select the correct answer from above options...
asked Dec 9, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...