Double quotes Problem
From: Aidan Leonard <AidanL_at_Peregrine.ie>
Date: Mon, 6 Mar 2000 11:36:01 -0000
Message-ID: <8a05so$kqv$1_at_kermit.esat.net>
Hi there
Date: Mon, 6 Mar 2000 11:36:01 -0000
Message-ID: <8a05so$kqv$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" .As the result, the data is not able to be loaded into Oracle. A rollback occurred.
How to resolve this issue?
Thanks
Regards,
Aidan
Received on Mon Mar 06 2000 - 12:36:01 CET