Ticket #343 ( Pending Customer )

Short Description Dates
Entered By: am2782 When: 1999-06-25 13:45:51 Build: 1.03.07A
Categories Type: Question   Department: Product   Category: ODBC Support
Description
 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 -->
   <TEDECLARE DBSOURCE
    NAME="EventLog"
    DATASOURCE="ROCWEB"
    USERID="rocupd"
    PASSWORD="rocupd"
    OPTIONS="SingleThreaded"
    SCOPE="SESSION">

   <TEDECLARE DBCOMMAND
    NAME="InsertEvent"
    DBSOURCE="EventLog"
    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">    

</PRE>
Append By: WindSurfer  When: 1999-06-26 10:49:21  New Status: Pending Customer
Comment 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 surfer@ieinc.com, referencing ticket #343?

While we investigate, can you also see if it will work using scope="global"?

Append By: am2782  When: 1999-07-02 14:19:18  New Status: Pending IE
Comment Oracle Version 7.3.4.0 ODBC Driver: Microsoft ODBC for Oracle 2.573.3711.00
Append By: WindSurfer  When: 1999-07-20 18:14:05  New Status: Pending Customer
Comment 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...