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!

Double Dash Mark in string causes ORA-01008: not all variables bound error

SharonJul 19 2011 — edited Jul 19 2011

Hello,
I have the following in a PL/SQL page process in APEX : v_student_name := :P31_LAST_NAME||', '||:P31_FIRST_NAME||'--'||:P31_STUDENT_ID;
I am running APEX 3.0.1 on Oracle Database 10g Express Edition.

When I use one dash, I do not get an error. When I use a double dash, I get the error : ORA-01008: not all variables bound error. Any suggestions on how to fix this problem would be greatly appreciated. Thanks in advance!

Sharon

This post has been answered by 807466 on Jul 19 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2011

Added on Jul 19 2011

#apex-discussions, #em, #html, #plsql

4 comments

1,259 views