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_at_bsg>
Client
NT 4.0 SP3 (Workstation)
NT 4.0 SP3 (Server)
S1000:[Oracle][ODBC][Ora]ORA-01036: illegal variable name/number
CREATE TRIGGER ASS_AUD BEFORE INSERT OR UPDATE ON ASSOCIATIONS FOR EACH ROW BEGIN
:new.UPDATE_ID := USER;
[Quoted] :new.UPDATE_TIME := SYSDATE;
END; Received on Thu May 13 1999 - 17:29:41 CEST
Date: 13 May 1999 15:29:41 GMT
Message-ID: <01be9d55$905f53a0$3400a8c0_at_bsg>
[Quoted] 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.
[Quoted] 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;
[Quoted] :new.UPDATE_TIME := SYSDATE;
END; Received on Thu May 13 1999 - 17:29:41 CEST