Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

ORA-00933: SQL command not properly ended. CF9 Error Executing Database Query, using ojdbc6 driver with Insert statement using select query.

Guest
Jul 10, 2015 Jul 10, 2015

Hi,

When using the CF9 in-build Oracle driver, the query works well, but when it is changed to use the ojdbc6.jar, then getting the below issue.

ORA-00933: SQL command not properly ended.

Issue particularly happens when we do an Insert using a select query inside cfquery. i.e.

INSERT INTO Table1  (  id  , name  , viewtime  )  SELECT   tab_id as id  , name  , viewtime  From Table2

3.4K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Jul 10, 2015 Jul 10, 2015

What is your reason for changing the driver?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jul 10, 2015 Jul 10, 2015

Because we are migrating from oracle 11g to 12c and the CF embedded driver does not work with oracle 12c.

For the next Question, yes we are planning to migrate the app to CF 11, but oracle is queued first.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Jul 10, 2015 Jul 10, 2015

CF9 does not support 12c. You will have to upgrade to CF11 before changing to 12C

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jul 12, 2015 Jul 12, 2015

haxtbh, Shall we run into some other issue rather than the driver if we use Oracle 12c with CF9, please educate if you see any other issue.

Further info, we are getting the above issue only on one server and the error details below,

ORA-00933: SQL command not properly ended.

VENDORERRORCODE       933

SQLSTATE       42000

SQL

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Jul 13, 2015 Jul 13, 2015
LATEST

As well as compatibility issues with CF9, the error you are getting is related directly to Oracle. You could be using outdated SQL that has now been fully depreciated in 12c. You will be better asking somewhere that helps with Oracle related queries.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources