/ / error ORA-06553: PLS-221: ‘G_VAR’ is not a procedure or is undefined Answer Obviously, you cannot call an internal variable of a package like that, presumably might convert to this one and call like this : or this : Edit : Indeed, not needed; you can alternatively call the statement by using EXECUTE IMMEDIATE as desired such as
Tag: plsql-package
Multiple functions calling a same function. I need to create a flag
Multiple functions calling a same function. I need to create a flag. Suppose I have 4 functions(f1,f2,f3 and f4) in a PLSQL package. F1 is being called by F2,F3 and F4. All I want a flag in order to track which function call the F1. For example . If f2 called f1 then flag=2,flag=3 when f3 called f1 and so
Why PLSQL optimize level is not providing expected result?
I am trying to understand complier optimizations in plsql in depth. Theoretically, default optimisation level PLSQL_OPTIMIZE_LEVEL is set to 2. To get better performance, we can set it to 3. To …