I am new to DBI. I wrote a simple program and I get the following in =
prepare method.
DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD: =
error possib
ly near <*> indicator at char 8 in 'SELECT <*>FROM GIGE WHERE =
CUSTOMER_SITE LIK
E '%Middletown%'')
What may be going on.
Abhay
On Tue, 2005-09-13 at 07:46 -0500, Jain, Abhay K, ALABS wrote:
> I am new to DBI. I wrote a simple program and I get the following in prepare method.
>
> DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD: error possib
> ly near <*> indicator at char 8 in 'SELECT <*>FROM GIGE WHERE CUSTOMER_SITE LIK
> E '%Middletown%'')
>
Are you selecting anything? i.e. Select * from gige....
> What may be going on.
>
> Abhay
>
--
Scott T. Hildreth
------=_Part_2649_628806.1126618125103
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Can you post the code that is producing that error?
On 9/13/05, Jain, Abhay K, ALABS
>=20
> I am new to DBI. I wrote a simple program and I get the following in=20
> prepare method.
>=20
> DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD: error=
=20
> possib
> ly near <*> indicator at char 8 in 'SELECT <*>FROM GIGE WHERE=20
> CUSTOMER_SITE LIK
> E '%Middletown%'')
>=20
> What may be going on.
>=20
> Abhay
>
------=_Part_2649_628806.1126618125103--
You need to lean Oracle's version of SQL. Read this doc:
http://download-west.oracle.com/docs/cd/B10501_01/server.920 /a90842.pdf
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Jain, Abhay K, ALABS [mailto:jainabhay@att.com]=20
Sent: Tuesday, September 13, 2005 6:47 AM
To: dbi-users@perl.org
Subject: prepare failing
I am new to DBI. I wrote a simple program and I get the following in
prepare method.
DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD:
error possib ly near <*> indicator at char 8 in 'SELECT <*>FROM GIGE
WHERE CUSTOMER_SITE LIK E '%Middletown%'')
What may be going on.
Abhay
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.