Bracket within a bracket
From: Aidan Leonard <AidanL_at_Peregrine.ie>
Date: Tue, 21 Mar 2000 17:07:55 -0000
Message-ID: <8b8avo$uf0$1_at_kermit.esat.net>
Hi There!
Date: Tue, 21 Mar 2000 17:07:55 -0000
Message-ID: <8b8avo$uf0$1_at_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.
Thanks in advance
Aidan Received on Tue Mar 21 2000 - 18:07:55 CET