| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PLS-00225
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
<ORACLE-L_at_fatcity.com>
<rdmorton_at_swi cc:
tch.com> Subject: PLS-00225
Sent by:
root_at_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
)
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
rdmorton_at_switch.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: rdmorton_at_switch.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Apr 24 2001 - 16:16:01 CDT
(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: Riyaj_Shamsudeen_at_i2.com 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: ListGuru_at_fatcity.com (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).
 |
 |