Skip to Main Content

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!

APEX 4.2 : SQL Workshop -> SQL Commands: Issue with bind variables

Hari_639Sep 7 2012 — edited Sep 8 2012
Dear APE Team,

When I run following query under SQL Commands @ apex.oracle.com,
SELECT * FROM DUAL WHERE :P1_BIND = 'a,b';
and when I enter the value of bind variable as a,b in the prompt window, then automatically its getting converted into a and the result is No data found

I think it's trying to escape comma and somehow its not working fine. Can you please look into this.

Please advise me if I am missing something. Thank you very much!

Regards,
Hari
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2012
Added on Sep 7 2012
2 comments
503 views