| insufficient priv's [message #43675] |
Mon, 18 August 2003 05:58  |
Vishv
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
while executing procedure i am getting this error.
though i have all the privileges with which i can create procedures/tables/views
The following error has occurred:
ORA-01031: insufficient privileges
ORA-06512: at "BOHRDB.CHEKCK", line 5
ORA-06512: at line 2
the sequence of the procedure is in this way
BEGIN
EXECUTE IMMEDIATE 'drop table bo_ohr_exit_dump';
END;
COMMIT;
BEGIN
EXECUTE IMMEDIATE 'rename bo_ohr_temp to bo_ohr_exit_dump';
END;
BEGIN
EXECUTE IMMEDIATE 'create table bo_ohr_temp as select * from bo_ohr_exit_Data WHERE 1=2';
END;
drop and rename commands r working fine but while creating its showing me this error,
if i issue the same command in sqlplus, it works but not in this procedure.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
