Disabling parameter prompting notation (&) in Pro*C code

From: <jmahoney_eclipsys_at_my-deja.com>
Date: 2000/06/02
Message-ID: <8h8ht6$obq$1_at_nnrp1.deja.com>#1/1


I have run into a problem running statements that use values that contain the variable/parameter prompting notation of an ampersand (&). In SQLPlus, you can turn this off by declaring a different character to designate a prompt or turn off promping altogether with command: set scan off; Is there a Pro*C option that I can declare in my code to turn off the scanning for prompting characters so that I can use the literal '&' value instead of Oracle interpreting as a special character. No luck on finding this in the online doc.

Any comments or info would be helpful.

Thanks in advance.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 02 2000 - 00:00:00 CEST

Original text of this message