SQL & PL/SQL

Hi,

Oracle9.2
Windows

There are two schema users A & B

User A grants select privilege to user B on tables
User A grants execute privilege to user B on packages

Now, on executing package from user B, gets the below error:

Execute below code from User B to retrieve the record from the table of user A

Declare
v_sid tab_user_A.column1%TYPE;
v_pid tab_user_A.column2%TYPE;
v_value tab_user_A.column3%TYPE;
v_pname tab_user_A.column4%TYPE;
v_cur package_user_A.Cursor1;
Begin
package_user_A.procedure_one(0,0,1,1,v_cur);
dbms_output.put_line(v_value);
End;


Error
-------

ORA-06550: line 2, column 13:
PLS-00201: identifier 'tab_user_A.column1' must be declared
ORA-06550: line 2, column 13:
PL/SQL: Item ignored
ORA-06550: line 3, column 16:
PLS-00201: identifier 'tab_user_A.column2' must be declared
ORA-06550: line 3, column 16:
PL/SQL: Item ignored
ORA-06550: line 4, column 9:
PLS-00201: identifier 'tab_user_A.column3' must be declared
ORA-06550: line 4, column 9:
PL/SQL: Item ignored
ORA-06550: line 5, column 10:
PLS-00201: identifier 'tab_user_A.column4


How to get it solve ?


With Regards