AW: [opencms-dev] Problem with Oracle sql script

[Stefan Marx]

Hi Kyrill,
 
in one of your last mails you wrote:
~~~~~~~~~~~~~~~~~~~~~~~~~
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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
First off all: IMHO no!
In my environement I have no problems compiling the package:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL*Plus: Release 8.1.6.0.0 - Production on Fr Jun 1 10:47:59 2001
 
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
 

Verbunden mit: 
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
 
SQL> select text from user_source where line = 76 and name = 'OPENCMSGROUP'
;
 
TEXT
----------------------------------------------------------------------------
----
     OPEN curGroups FOR 'select g.* from cms_groupusers gu, cms_users u,
cms_gro
ups g'||
 

SQL> alter package OPENCMSGROUP compile ;
 
Paket wurde geandert.
 
SQL> 
~~~~~
Unfortunatly, the PLSQL Error 103 is fairly ... generic and unprecise:
BM_1000575
PLS-00103 found 'string' but expected one of the following: 'string'"},

BM_1000576
Cause: This error message is from the parser. It found a token (language
element) that is inappropriate in this context.

BM_1000577
Action: Check previous tokens as well as the one given in the error message.
The line and column numbers given in the error message refer to the end of
the faulty language construct.

I use the OpenCms 4.3.15 Beta Version - but that package of the Oracle
driver is integrated for several month.

Look at the lines in the sql code, especialy line #76 for obstacles for the
SQL parser, may be the code is damaged. Reinstall

the oracle objects with the DML statements if you are in doubt concerning
the sanity of the package source. Look out if all 

you objects (especially tables) are created.

Good luck,

Stefan

Stefan Marx 
Manager Application Server 
--------------------------------------- 
Framfab Deutschland AG 
Augustinusstrasse 9c 
D 50226 Frechen 
GERMANY 
mailto:stefan.marx at framfab.de <mailto:stefan.marx at framfab.de>  
http://www.framfab.de <http://www.framfab.de/>  
Phone +49 (0)2234 . 699 334 
Fax     +49 (0)2234 . 699 335 
--------------------------------------- 

We transform your business! 
The Framfab Deutschland AG  transforms business 
processes in the Network Economy - 
for clients, including AXA, 3M, Quelle Versicherungen and BHW. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20010601/2a1f0617/attachment.htm>