Double quotes problem

From: Aidan Leonard <AidanL_at_Peregrine.ie>
Date: Mon, 6 Mar 2000 11:37:09 -0000
Message-ID: <8a05us$kr7$1@kermit.esat.net>

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.

Figure 1

How to resolve this issue?

Thanks

Regards,
Aidan Received on Mon Mar 06 2000 - 05:37:09 CST