Oracle ODBC Question

From: Barry Gilchrist <barry.gilchrist_at_intactix.co.uk>
Date: 13 May 1999 15:29:41 GMT
Message-ID: <01be9d55$905f53a0$3400a8c0@bsg>

I have been using an ODBC connection to Oracle to execute a variety of SQL statements.
These statements include table creation, indexing, foreign key definitions and the creation of triggers.

Using the Oracle 7 drivers against Oracle 7.3.4 the statements are executed without error.
Using Oracle 8 drivers against an Oracle 8.0.5 database an error occurs (see below).
Using Oracle 7 drivers against an Oracle 8.0.5 database is successful.

In the above three cases the statements being executed are the same and where an error occurs it is always the first CREATE TRIGGER.

Can anyone throw any light on this matter.

Regards
Barry Gilchrist
Intactix International Ltd.

---

Client

---

NT 4.0 SP3 (Workstation)

Server

---

NT 4.0 SP3 (Server)

Error

---

S1000:[Oracle][ODBC][Ora]ORA-01036: illegal variable name/number

Drivers

---

ORACLE ODBC Driver 	8.00.0500
Oracle73 Ver 2.5	2.05.0301

SQL Statement

---

CREATE TRIGGER ASS_AUD BEFORE INSERT OR UPDATE ON ASSOCIATIONS FOR EACH ROW BEGIN
:new.UPDATE_ID := USER;
:new.UPDATE_TIME := SYSDATE;

END; Received on Thu May 13 1999 - 10:29:41 CDT