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!

Bind variable vs. substitution string vs. v and nv functions

dmcghanJun 11 2008 — edited Jun 11 2008

Hello,

As I've always understood it, bind variables are supposed to be used in SQL and the v and nv functions in PL/SQL. However, after reading Sara Blair's post, available here: http://www.apex-blog.com/oracle-apex/using-built-in-substitution-strings-tutorial-part-1-25.html , I got to thinking, when is the best time to use the various options? Could anyone explain with some details?

Also, it is possible to set an items session state with bind variable syntax in PL/SQL I've always used apex_util.set_session_state... Is that the correct choice?

Regards,
Dan

http://danielmcghan.us/
http://sourceforge.net/projects/tapigen/

Removed comma.
Message was edited by:
dmcghan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2008

Added on Jun 11 2008

#apex-discussions

4 comments

1,620 views