Re: IF Condition

Posted by ErmanArslansOracleBlog on May 20, 2022; 4:02pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/IF-Condition-tp10924p10925.html

Did you check if you can see the pdb name using sys_context after executing -》 execute immediate ( 'alter session set container="myPDB" ');
Because we have a bug there.. that s why I m asking it.

Bug 22743059 - EBS MULTITENANT: SYS_CONTEXT('USERENV','DB_NAME') TO RETURN PDB NAME

Can you just get the value of a env variable using $$ there in plsql?
And why dont you use the sys_context there in the if condition as well?