The simple query is not enough. Send in a part of your script that
demonstrates the problem, so that someone can comment. Try using quote()
that might help, though I'll have to take a look at everything else you are
doing.
Ilya
-----Original Message-----
From: Martin Hesse
To: [EMAIL PROTECTED]
Sent: 1/7/02 10:11 AM
Subject: Placeholders :<decimal> in Oracle
Hello all,
I need some little advice about placeholders in the form of :1, :2, ...
please.
I want to insert a String of tbe form 'xxx:0' into a LONG-Field in an
Oracle-database. This is _not_ thought to be a placeholder.
When I prepare an INSERT-Statement that contains :0 in it (e.g. INSERT
INTO MYTABLE (FOO LONG) VALUES ('xxx:0') ) I get an error that says
Placeholder :0 invalid, Placeholder must be >= 1. I tried to prefix
every :<decimal> with '\' and this doesn't seem to work either because I
get the same error message as without the '\'.
I looked it up in Mr. Bunce's Book but it just says that anything in the
form of :<decimal> can be a placeholder but not how to invalidate that
syntax.
So how do I get that ':0' in my LONG-Field as plain text ?
Thanks for helping,
Martin
--
Martin Hesse [EMAIL PROTECTED]
nova ratio AG - IT-Systemhaus fuer Produkte und Dienstleistungen
Ransbach-Baumbach
Germany
[EMAIL PROTECTED]
Tel. : 02623 92420 Fax. : 02623 9242100
The information contained in this e-mail and any attachments is strictly
confidential and may be legally privileged. It is intended solely for
the use of the individual or entity to whom it is addressed. If you are
not the named addressee, you are hereby notified that it is prohibited
and may be unlawful to disclose, copy, distribute or store the
information contained in this email.
