Recent questions tagged oracleplsql

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: ORA-01086: savepoint 'L_SAVEPOINT' never established in this session or is invalid

In my case, savepoint was set in Java and I am trying to rollback in a plsql procedure which was ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jun 1, 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