Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PACKAGE, CURSER & ORA-00942: table or view does not exist

PACKAGE, CURSER & ORA-00942: table or view does not exist

From: Mats L <matsla_at_hotmail.com>
Date: 9 Aug 2002 02:18:50 -0700
Message-ID: <2d83b9f.0208090118.12c67fc5@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US