Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Parameters entered in Set Parameters tab are not propagated to anonymous block.
설명
During execution of PL/SQL package from the Schema browser by clicking the right mouse button on the package, and clicking "Execute Package", the window "Set Parameters" appeared. Then values was entered at the tab "Arguments" but not all entered parameters appeared in the tab "Anonymous Block Code". The tab "Anonymous Block Code" shows "NULL" values for these variables.
해결 방안
It is necessary to check check box "Expression" next to the check box "Null". See the screenshot with example below.