I am trying to update a date field in an ORACLE Database using and Insert Statement in a DBCOMMAND without any success.
<!-- Create the ODBC Connection -->
SQL="INSERT INTO ROCTEST
(EVENT_ID, EVENT_TYPE, EVENT_MODULE, EVENT_DATE,
PARENT_ID, PEOPLE_ID, DESCRIPTION, ST_UPDATE_TEXT)
VALUES ( ?N(38), ?V(6), ?V(10), ?C(10), ?N(38),
?N(38), ?V(2000), ?V(40))">
<!-- Execute the Stored Procedure -->
<TEDBEXEC InsertEvent 1 "COSMAC" "Activity"
'25-JUN-1999' 1 1 "Test Insert" "Test Insert">
We will be setting-up a test environment for both ticket 340 and this ticket on Monday.
Which version of Oracle and which version of the ODBC driver are you using?
Also, can you e-mail a log of this occurring as well as the DDL for the table involved to email@example.com, referencing ticket #343?
While we investigate, can you also see if it will work using scope="global"?
Still trying to get our environment set-up to test...afraid we can only find Oracle 7.1 for NT--will try without some of the data extent definitions in your DDL.
Never actually got a log (got the .sql file)...sorry for the delay in turning this around, but we are committed to making Screensurfer work for you...any chance of still getting a log of this failing?
The N(38) definitions are a possible problem-- Screensurfer just uses a standard double float and will ignore the (38), so this could be an issue...