SQL Execution

asliakar · Post by **asliakar** » Tue 15 Mar 2005 14:54

Hello,

I am using ODAC 5.10.4.13 for delphi 6. My OS is Win XP. And Oracle version is 8i. I have oracle client installed in my machine.

1. When i try to run an SQL statement - which is proper im sure, it works well with DBA studio and ADO as well - I get the message "ORA-00933: SQL command not properly ended." As this is a proper Sql, what is wrong?

2. I am working with oracle spatial. I can open my spatial tables in ODAC without NET option.. But as i cannot debug, i tried to open it with Net option, but this time, "DataType is not supported" although the spatial column is not included in the query...

Any clues or solutions will be wellcome. I have immigrated my source from ADO but could not make it work yet

Alex · Post by **Alex** » Wed 16 Mar 2005 08:44

Please specify your proper SQL and we try to resolve this problem.
As to your second question we couldn't reproduce your problem with object
fields, maybe there are some else fields that have object type in your SQL,
try to designate this field by excluding fields from SQL one by one, if the
problem persists send us small demo project to demonstrate your problem and
include script to create server objects to ODAC support address.

asliakar · Post by **asliakar** » Fri 18 Mar 2005 09:08

The table is something created using below ddl :

"CREATE TABLE WWW ( OBJECTID NUMBER(9) NOT NULL, POLY BLOB, CLLX FLOAT(126), CLLY FLOAT(126), CURX FLOAT(126), CURY FLOAT(126), PRIMARY KEY (OBJECTID) )"

and, in this table, when a few records are created, then, the following sql is tried to be executed is:

"Select min(CLLX) as MINCLLX,min(CLLY) as MINCLLY,max(CURX) as MAXCURX, max(CURY) as MAXCURY From WWW WHERE ((CLLX0) AND (CLLY0) AND (CURX0) AND (CURY0))"

and the error message after the executıon attempt is :
"ORA-00933: SQL command not properly ended"

The Select statement could be run in both from an ADO connection or Oracle DBA Studio... Is there something wrong with the SQL functions?

Thank you...

Alex · Post by **Alex** » Fri 18 Mar 2005 11:44

We couldn't reproduce your error with SQL execution, may be there are some else circumstances that affect on application behaviour, pls. send us small demo project that demonstrates your problem and include scripts to create server side objects to ODAC support address.