SQL & PL/SQL

Hello All,

thanks for readying my query. I am getting "insufficient privileges" error when i am trying insert into a view (where view is constructed with a constant value).

SQL> create view tt ("a") as select 100 as "a" from dual;

View created.

SQL> insert into tt values(10);
insert into tt values(10)
*
ERROR at line 1:
ORA-01031: insufficient privileges

From the same session, I dont get any error if the view is constructed with a base table.

SQL> create table tzz(i int);

Table created.

SQL> insert into tzz values(12);

1 row created.

Is there any way to get more information regarding the error ? something like "View is not updatatable bez view constructed with constatnt" , instead of saying "Insufficient privleges". The error "insuffcient privileges" is misleading.

If PL/SQL procedure fails, we get error saying "Compiled with errors". Then if we ask for more "show errors" , it will show all the errors.
Is there anything like that in my above question also which will show exact error for failure instead of saying "insufficient privileges". \

Thanks in advance for the reply
Venkatesh.