Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PACKAGE, CURSER & ORA-00942: table or view does not exist
If i create a user (not the object owner) with execute permission on
the package function and select permission on the table this works in
9i but fails in 8.1.6 with ORA-00942: table or view does not exist. If
i change the FROM clause to include the schema owner APP.TAB this in
8.1.6 works but i don't like to do this.
Any ideas why this dosn't work in 8.1.6?
// Mats
CREATE OR REPLACE PACKAGE BODY X AS
PROCEDURE LOAD (
TRANSCURSOR IN OUT TRANSCUR)
IS
BEGIN
OPEN TRANSCURSOR FOR
SELECT F1, F2 FROM TAB
END LOAD;
END X;
Received on Fri Aug 09 2002 - 04:18:50 CDT