Simple PL/SQL Problem

Hello All,

I am as green as they come, so forgive me if this the answer to this is painfully obvious. I have no one else in the company I can ask, so please humor me.

My problem is this: I cannot reference a table in another users schema while trying to compile a PL/SQL procedure. For example, a table exists called 'students' created by a user 'bozo'. The table has 3 elements: first_name, last_name, student_id.

I am connected as 'krusty' and I am trying to compile a procedure that references the 'students' table of 'krusty's. For each variable in the table, I reference them as follows:

v_FirstName    bozo.students.first_name%TYPE
v_LastName    bozo.students.last_name%TYPE
v_StudentID    bozo.students.student_id%TYPE

Later, the procedure tries to insert into the table as follows:

INSERT INTO bozo.students(v_FirstName, v_LastName,v_StudentID) AS VALUES (n_FirstName,n_LastName,n_StudentID) ;

I get a PLS-201 error which is complaining about me not declaring the 'BOZO.STUDENTS' identifier.

I can successfully compile this procedure all day long as the user bozo, but as krusty I constantly get the error described above. I have granted damn near every privilege to krusty known to humankind.

Any hints, tips, clues would be greatly appreciated.

Scuffling,
Sean Phillips Received on Wed Mar 11 1998 - 00:00:00 CST