PLS-00225

2001-04-24 Thread Morton, Ronald D
Hi, I just ran into a problem with v8.1.6 on Linux whereby my stored procedure won't compile because it claims that a table reference is out of scope. It complains about the definition of the arguments to the stored procedure which are as follows: CREATE OR REPLACE PROCEDURE rollup_insert (

RE: PLS-00225

2001-04-24 Thread Haskins, Ed
Ron, Yes, there is a KEYWORD called ROLLUP which is used in Dimensions typically found in a DW environment. I'm surprised that Oracle has not added this to there list of Oracle Reserved Words. Hopefully the following will help: Ed Haskins Oracle DBA Verizon Wireless ROLLUP ROLLUP enables a

RE: PLS-00225

2001-04-24 Thread Morton, Ronald D
Subject: RE: PLS-00225 Ron, Yes, there is a KEYWORD called ROLLUP which is used in Dimensions typically found in a DW environment. I'm surprised that Oracle has not added this to there list of Oracle Reserved Words. Hopefully the following will help: Ed Haskins Oracle DBA Verizon