<!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.4611.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi all</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've some problems with Oracle Database
scripts.</FONT></DIV>
<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>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Please help me to solve this problem.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Kyrill</FONT></DIV>
<DIV><FONT face=Arial
size=2>________________________________<BR>T-Systems<BR>debis IT Services CIS
Saint-Petersburg<BR>voice: +7 812 3467993<BR>fax: +7 812
3274900</FONT></DIV></BODY></HTML>