Hi all,
I'm trying to select records from a table, using a store procedure, but I get:
Errore(13,10): PL/SQL: ORA-01031: privilegi insufficienti
at Line 13 there is :
select k_id into id from schema1.t_table_var where k_id=12;
In schema1 i granted
grant insert,update, delete on t_table_var to ico
and if I try to run the query directly (non in a pl/sql procedure) I can get the results; Besides if i try to make a select to another table but in the schema schema1) I can get the result....... I'm getting crazy;
So what I have to do in order to use a table inside a different schema, in a pl/sql procedure?