Strings as Parameters containing &

An existing system here allows users to save some critical varchar2 fields containing ampersands (&). Another system is reading these fields, and via ODBC calling Oracle Stored Procedures (v7.3) using the string contents as parameters.

The OSPs are immediately crashing when the strings contain &.

For example: p1 = '106'
p2 = 'User Named & Causing Problem'

call osp passing p1, p2

<crashes>

In Pl/SQL I can set define off and deal with ampersands while tooling around with PL/SQl. Is there some setting that can be applied globally to this user (all users use a single login) so that oracle will ignore special characters when in strings?

Thanks
Jeff Smith Received on Wed Jan 24 2001 - 11:29:19 CST