[opencms-dev] Problem with Oracle sql script

[Kyrill A. Ouglev]

Hi all

I've some problems with Oracle Database scripts.
I'm using the Oracle 8 Release 8.0.5.0.0 installed on UNIX server.
When I run sql script all tables created OK, but packege body created with compilation errors.
Bellow you may see one of their errors:

Errors for PACKAGE BODY OPENCMSGROUP:

73/25    PLS-00103: Encountered the symbol "select g.* from cms_groupusers
         gu, cms_users u, cms_groups g" when expecting one of the
         following:
         select
         The symbol "select" was substituted for "select g.* from
         cms_groupusers gu, cms_users u, cms_groups g" to continue.

May be I mast use Oracle 8i for correct running this script?

Please help me to solve this problem.

Kyrill
________________________________
T-Systems
debis IT Services CIS Saint-Petersburg
voice: +7 812 3467993
fax: +7 812 3274900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20010601/137a28a9/attachment.htm>