After I execute/compile a stored procedure/function, I query the all_statements view to extract the statements that were in the stored procedure/function like below: However, one of my applications run the following code: Whenever this code is run, the all_statements view is cleared. Even if I execute this same function like below: There are no new entries in all_statements showing the
Tag: plsql
How to correctly develop, upload java library with dependencies to Oracle DB and call my Java function from PLSQL?
I have: Oracle 19c java 8 on its machine What i did: I write simple class with one method in Java 8. I compile my project with maven and maven-assembly-plugin to build .jar file with dependencies. I upload it with loadtool: loadjava -f -r -v -synonym -oracleresolver -resolve -grant <user> -thin -user <credentials> <filename>.jar There were 0 errors during upload.
Translation from Java to Oracle SQL: use every element into a loop as result of a SELECT statement [closed]
It’s my first time using Oracle function. I’m trying to translate this piece of code in Java to Oracle SQL. It’s present a SELECT statement before the loop for (int i = 0; i < checkList....
Is there a algorithm to resolve credit rating?
I need to implement a logic in either Java OR SQL for the following. There are credit ratings from numbers 1 to 11. And corresponding to each rating say x, I have 3 grades, effectively :x+, x and x-. …
How to extract line with syntax error when parsing PlSQL using Antlr4
I am using the grammar file for PlSql from this Github repository. I want to underline the line in plsql file that I parse if it has a syntax error. I have the following snippet to do so: While this works fine in most cases, some scripting languages, like PlSql, need special handling for case-sensitivity. This means I had to
Catching RAISE_APPLICATION_ERROR with springframework SimpleJdbcCall
I have a PL/SQL procedure where I call if something goes bad. This seems to work, because the procedure quits and throws the error when it should. I call this procedure using But when I catch the exception, it is of type DataAccessException. The cause is ORA-01403: no data found There doesn’t seem to be a way for me to
Returning multiple ref cursors from Oracle procedure to Java
In our web application we have 18 screens in a module. Our user wants all the data of the 18 screens in one page so that they can print the entire data at once. So, I wrote an Oracle procedure which …