macromedia.coldfusion.database_access
[Top] [All Lists]

Re: ora-00933 with JDBC thin

Subject: Re: ora-00933 with JDBC thin
From: "pkulla" <webforumsuser@xxxxxxxxxxxxxx>
Date: Thu, 24 Jan 2008 11:28:27 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

The SQL is something like:

 insert into fu_dokument_status (oid, benutzer, status, datum) 
    (select 123, 'asdf', 'gelesen', sysdate from dual 
      where not exists (select * from fu_dokument_status where oid=123 and 
benutzer='asdf' and status='gelesen' ) 
    )

 As far as I could find out for now, is that the problem occurs ONLY using CF8 
and ojdbc14.jar from Oracle 10g.
 CF7 works fine both using 10g or 9i driver. Also when using CF8 with the 
ojdbc14.jar in the 9i version the above SQL works, even accessing a 10g 
database.

 Any Ideas?

 Peter



<Prev in Thread] Current Thread [Next in Thread>