Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Facing Issue when saving select list item after adding some commented code

rohitpintu2002Jul 12 2019 — edited Jul 12 2019

I have created one select list item under apex 18 and its list of value type is SQL query when I am adding some commented query with this select query then it automatically change in PL/sql Function body returning sql query. Please see below image and guide us for this issue.

Step 1: Here I have created one select list item name as p1_new

p1.png

Step 2: Initially I select type as SQL query and wrote one script

p2.png

Step 3: Here I wrote below query

p3.png

Step 4: I save it and it shows as SQL query see below screen. Here it's type as SQL Query

p4.png

Step 5: Now I simply edit code editor and added one commented sql qery and once again save it. Here I am not changing type.

p6.png

Step 6: After saving item type got change as PL/SQL Function Body Returning SQL query see below image

p7.png

If I remove commented code from here and save it then it working fine. Please suggest on this issue.
Comments
Post Details
Added on Jul 12 2019
#apex-discussions
1 comment
509 views