I was used to MySql syntax, but now I'm trying to study Oracle. Let's take a look at the following stored procedure(using SQL Developer):
CREATE OR REPLACE PROCEDURE myPROC(aux OUT NUMBER, par1 IN VARCHAR2, par2 IN VARCHAR2) AS BEGIN COMMIT; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; --OR READ COMMITTED(any, does not matter) END myPROC;
I've read official documentation but I still cannot figure how to set isolation level for a stored procedure transaction or session. This code is compiled but with errors. How can something be successfully compiled, BUT with errors.
I have used show errors but still not very useful hints... Any advice? I have to mention that it's somehow pointing to the set transaction line...