I still don't see anything in what you just posted that shows this
And you didn't post the confirmation that level was really '2' for the system AND for those two procedures.
And when you post related threads you should cross-link them so people can try to understand the entire context of what you are doing. plsql_optimize_level parameter resets itself
What you posted shows you created the procedures BEFORE you set the LEVEL. And you didn't post the confirmation that level was really '2' for the system AND for those two procedures.
1. drop the procedures
2. set the level to '2'
3. create the procedures
4. rerun the test
It works now :)) Thank you.
I did it with using SQL*PLUS instead of SQL DEVELOPER. First, I used SQL DEVELOPER I could not get the right results. However, SQL*PLUS works correct!
So, the question is why? This is very serious problem I think.