<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=koi8-r">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=831584908-01062001>Hi
Kyrill,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=831584908-01062001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=831584908-01062001>in one
of your last mails you wrote:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=831584908-01062001>~~~~~~~~~~~~~~~~~~~~~~~~~</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=831584908-01062001>
<DIV><FONT face=Arial size=2>I'm using the Oracle 8 Release 8.0.5.0.0 installed
on UNIX server.</FONT></DIV>
<DIV><FONT face=Arial size=2>When I run sql script all tables created OK, but
packege body created with compilation errors.</FONT></DIV>
<DIV><FONT face=Arial size=2>Bellow you may see one of their
errors:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Errors for PACKAGE BODY OPENCMSGROUP:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>73/25 PLS-00103: Encountered the
symbol "select g.* from
cms_groupusers<BR> gu, cms_users
u, cms_groups g" when expecting one of
the<BR>
following:<BR>
select<BR> The symbol "select"
was substituted for "select g.*
from<BR> cms_groupusers gu,
cms_users u, cms_groups g" to continue.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>May be I mast use Oracle 8i for correct running
this script?</FONT></DIV></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=831584908-01062001>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=831584908-01062001>First
off all: IMHO no!</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=831584908-01062001>In my
environement I have no problems compiling the package:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=831584908-01062001>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=831584908-01062001>SQL*Plus: Release 8.1.6.0.0 - Production on Fr Jun 1
10:47:59 2001</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=831584908-01062001>(c)
Copyright 1999 Oracle Corporation. All rights
reserved.</SPAN></FONT></DIV>
<DIV> </DIV><SPAN class=831584908-01062001>
<DIV><BR><FONT face=Arial color=#0000ff size=2>Verbunden mit: <BR>Oracle8i
Enterprise Edition Release 8.1.6.1.0 - Production<BR>With the Partitioning
option<BR>JServer Release 8.1.6.0.0 - Production</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>SQL> select text from user_source
where line = 76 and name = 'OPENCMSGROUP' ;</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff
size=2>TEXT<BR>--------------------------------------------------------------------------------<BR>
OPEN curGroups FOR 'select g.* from cms_groupusers gu, cms_users u,
cms_gro<BR>ups g'||</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><BR><FONT face=Arial color=#0000ff size=2>SQL> alter package
OPENCMSGROUP compile ;</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Paket wurde geändert.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>SQL> </FONT></DIV>
<DIV></SPAN><SPAN class=831584908-01062001><FONT face=Arial color=#0000ff
size=2>~~~~~</FONT></SPAN></DIV>
<DIV><SPAN class=831584908-01062001><FONT face=Arial color=#0000ff
size=2>Unfortunatly, the PLSQL Error 103 is fairly ... generic and
unprecise:</FONT></SPAN></DIV>
<DIV><SPAN class=831584908-01062001>
<DT class=M><A name=1000575></A>
<P><STRONG>PLS-00103 found '<EM class=Italic>string</EM>' but expected one of
the following: '<EM class=Italic>string</EM>'"},</STRONG></P>
<DD class=MH1><A name=1000576></A>
<P><STRONG>Cause: </STRONG>This error message is from the parser. It found a
token (language element) that is inappropriate in this context.</P>
<DD class=MH2><A name=1000577></A>
<P><STRONG>Action: </STRONG>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.</P></DD></DIV>
<P class=MH2><SPAN class=831584908-01062001>I use the OpenCms 4.3.15 Beta
Version - but that package of the Oracle driver is integrated for several
month.</SPAN></P>
<P class=MH2><SPAN class=831584908-01062001>Look at the lines in the sql code,
especialy line #76 for obstacles for the SQL parser, may be the code is
damaged. Reinstall</SPAN></P>
<P class=MH2><SPAN class=831584908-01062001>the oracle objects with the DML
statements if you are in doubt concerning the sanity of the package source. Look
out if all </SPAN></P>
<P class=MH2><SPAN class=831584908-01062001>you objects (especially tables) are
created.</SPAN></P>
<P class=MH2><SPAN class=831584908-01062001><FONT face=Arial color=#0000ff
size=2>Good luck,</FONT></SPAN></P>
<P class=MH2><SPAN class=831584908-01062001><FONT face=Arial color=#0000ff
size=2>Stefan</FONT></SPAN></SPAN></P>
<P><FONT face=Arial size=1>Stefan Marx</FONT> <BR><FONT face=Arial
size=1>Manager Application Server</FONT> <BR><FONT face=Arial
size=1>---------------------------------------</FONT> <BR><FONT face=Arial
size=1>Framfab Deutschland AG</FONT> <BR><FONT face=Arial
size=1>Augustinusstrasse 9c</FONT> <BR><FONT face=Arial size=1>D 50226
Frechen</FONT> <BR><FONT face=Arial size=1>GERMANY</FONT> <BR><U><FONT
face=Arial color=#0000ff size=1><A
href="mailto:stefan.marx@framfab.de">mailto:stefan.marx@framfab.de</A></FONT></U>
<BR><U><FONT face=Arial color=#0000ff size=1><A target=_blank
href="http://www.framfab.de/">http://www.framfab.de</A></FONT></U> <BR><FONT
face=Arial size=1>Phone +49 (0)2234 . 699 334</FONT> <BR><FONT face=Arial
size=1>Fax +49 (0)2234 . 699 335</FONT> <BR><FONT
face=Arial size=1>---------------------------------------</FONT> </P>
<P><FONT face=Arial size=1>We transform your business!</FONT> <BR><FONT
face=Arial size=1>The Framfab Deutschland AG transforms business
</FONT><BR><FONT face=Arial size=1>processes in the Network Economy -
</FONT><BR><FONT face=Arial size=1>for clients, including AXA, 3M, Quelle
Versicherungen and BHW.</FONT> </P></BODY></HTML>