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
(
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
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