Bracket within a bracket

Hi There!

The problem is that a statement is passed to Oracle from VB to execute a stored procedure package.

As the result, the statement looks like this :

{call sp_setup_case( 'A.T.M. (TM""$"")' ) }

Double quotes is needed to eliminate the problem where $ is identified as a variable.

Within Oracle, the double quotes will be removed. The information will be stored as 'A.T.M. (TM$)'.

However, because there is a bracket within a bracket, when passing through to Oracle from VB, it is rejected as "Unknown String Resource" (Figure 1).

As the result, the data is not able to be loaded into Oracle. A rollback occurred.

Thanks in advance

Aidan Received on Tue Mar 21 2000 - 11:07:21 CST