[redhat-ccm-list] Help installing CCM/CMS 6.1

Richard Li richardl at redhat.com
Thu May 6 02:49:41 UTC 2004


Did you try running the query in SQL*Plus to verify that it is indeed a 
SQL92 issue?

Tuan Nguyen wrote:

> Thanks Vadim,
>
> Your guess is correct, I am running on oracle 8.1.7. Is there a work 
> around for this issue.
>
> Tuan.
>
> Vadim Nasardinov wrote:
>
>> On Wednesday 05 May 2004 17:21, Tuan Nguyen wrote:
>>
>>> 2004-05-05 17:12:55,096 [ main] ERROR rdbms.RDBMSEngine - select
>>> t0.pdl_id as "this.id",
>>>        t6.object_type as "this.objectType",
>>>        t6.display_name as "this.displayName",
>>>        t6.default_domain_class as "this.defaultDomainClass",
>>>        t0.pdl_file as "this.pdlFile",
>>>        t0.dynamic_object_type as "this.dynamicType"
>>> from persistence_dynamic_ot t0
>>> join acs_objects t6 on t0.pdl_id = t6.object_id
>>> java.sql.SQLException: ORA-00933: SQL command not properly ended
>>
>>
>>
>> Have  you tried running this query in SQL*Plus?  What version of Oracle
>> are you using?  This looks like SQL92 syntax to me.  Probably works on
>> Oracle 9, but not, say, 8.1.7.
>>
>>
>
>






More information about the Redhat-ccm-list mailing list