select data from table owned by other user

Hi everybody!

I've to select some data from a table owned by another user "tmp_user" . When I run the following code:

CREATE OR REPLACE PROCEDURE ...
...

  BEGIN

     DECLARE
        CURSOR tmp_Cur IS
            SELECT * from tmp_table;

I always get the error-message:

    PLS-00201:identifier 'tmp_user.tmp_table' must be declared

I know that I've to declare 'tmp_table' before I can use it, but I could'nt find the syntax for that in oracle-docs.

any help would be fine..
Tom Received on Thu May 18 2000 - 00:00:00 CDT