Re: OCI: How can I insert a string including an amphersand (&) from OCI??

From: Ole Hansen <oha_at_unispeed.com>
Date: Mon, 14 Oct 2002 10:59:56 +0200
Message-ID: <3DAA878C.6010000@unispeed.com>

Hi,

I think I really messed up things here. This is an example of the code I use.

char query[200];

sprintf(query, "insert into some_table (a,b) values (25, 'abc&def')");

OCIStmtPrepare(stmthp,errhp,(text*)query,
   (ub4)strlen(query),(ub4)OCI_NTV_SYNTAX,(ub4) OCI_DEFAULT);
OCIStmtExecute(svchp, stmthp, errhp,(ub4)1,

   (ub4)0,(CONST OCISnapshot *)NULL,
   (OCISnapshot *) NULL,OCI_COMMIT_ON_SUCCESS);

Whenever I had a faulty insert I tried to execute the very same statement from sqlplus - and it failed too because the string also included an ampersand and I was prompted for a value.

However the problem seems to be something different which I will look into.

Thanks!

Ole

Finn Ellebaek Nielsen wrote:
> Hi Ole.
>
> What does your code look like?
>
> Using OTL -- a generic C++ template interface to Oracle etc. available from
> http://otl.sourceforge.net/home.htm -- the following simple example that
> inserts rows into SCOTT.DEPT works with strings containing &:
>
> #include <stdio.h>
>
> #include "otlv32.h"
>
> int main()
>
> {
> try {
> otl_connect connection("scott/tiger_at_o901");
> otl_stream statement;
>
> statement.open(1,
> "insert into dept " \
> "values (" \
> " :deptno<int>, :dname<char[15]>, :loc<char[14]>" \
> ")",
> connection);
>
> statement << 90 << "1" << "2";
> statement << 91 << "3" << "4";
> statement << 92 << "&5" << "&6";
> }
> catch (otl_exception &e) {
> printf("Exception: %s\n", e.msg);
> }
>
> return(0);
> }
>
> Cheers,
>
> Finn
>
> "Victor Kaminsky" <victorkaminsky_at_yahoo.de> wrote in message
> news:90a73003.0210121246.57f6feb1_at_posting.google.com...
>

>>Ole Hansen <oha_at_city.dk> wrote in message

>
> news:<3DA7F142.7060909_at_city.dk>...
>

>>>Hi,
>>>
>>>I have troble escaping an amphersand (&) from within OCI.
>>>Neither single quote (') or backslash (\) seems to work.
>>>
>>>The statement fails if I try to execute it from OCI if the string
>>>includes an amphersand but I dont know how to escape an amphersand (&).
>>>
>>>I really need to store the amphersand with the string.
>>>
>>>Any ideas?
>>>
>>>Thanks in advance!
>>>Ole Hansen
>>
>>maybe you could use the char() function. it is not nice, but could work

>
>
Received on Mon Oct 14 2002 - 03:59:56 CDT