Yep. Rollup is a key word introduced in 8i and it is the variants
introduced with group by clause...Also they are declared as dummy function
in standard package and parser will see that function before your table
name and hence the error..
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
"Morton,
Ronald D" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<rdmorton@swi cc:
tch.com> Subject: PLS-00225
Sent by:
root@fatcity.
com
04/24/01
03:47 PM
Please
respond to
ORACLE-L
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
(
vv_rollup_id OUT rollup.rollup_id%TYPE,
vv_warrant_id IN rollup.warrant_id%TYPE,
vv_rollup_limit_id IN limit.limit_id%TYPE,
vv_rollup_time IN VARCHAR2,
vv_rollup_emp_badge IN rollup.rollup_emp_badge%TYPE,
vv_exec_id OUT INT,
vv_rc OUT INT
)
AS
...
The specific error message complains that "rollup" is out of scope. If I
substitute base level types for these, the procedure will compile. I have
included the "rollup" table definition and ownership below for reference.
It is the TWS user trying to execute this procedure.
desc rollup
----------------------------------------------------------------------------
-----------------
ROLLUP_ID NOT NULL NUMBER
WARRANT_ID NOT NULL NUMBER
ROLLUP_TIME NOT NULL DATE
ROLLUP_TIME_TZ NOT NULL VARCHAR2(3)
ROLLUP_EMP_BADGE NOT NULL VARCHAR2(4)
ROLLUP_LIMIT_ID NOT NULL NUMBER
DATESTAMP DATE
select owner, object_name, object_type from dba_objects where object_name
like '%ROLLUP%';
OWNER OBJECT_NAME OBJECT_TYPE
----------------------------------------------------------------------------
--------------------
TWS ROLLUP TABLE
TWS ROLLUP_INSERT PROCEDURE
As you can see, the table and the procedure are owned by the same user.
The
table exists and the columns referenced in the arguments to the procedure
also exist.
What am I missing here? Is there a new keyword called ROLLUP somewhere?
Any help would be very much appreciated.
TIA
Ron Morton
Database Architect / Administrator
Union Switch & Signal Inc
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Morton, Ronald D
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
