executing Procedure problem [message #7867] |
Mon, 14 July 2003 02:54 |
Abu Arbab
Messages: 13 Registered: June 2003
|
Junior Member |
|
|
I am trying to execute the procedure using toad. when i execute the statements using begin ,end command thru toad as following it is working fine:-
begin
EXECUTE IMMEDIATE 'drop materialized view QAP_MS_VIEW';
EXECUTE IMMEDIATE 'create materialized view QAP_MS_VIEW as select * from QAP_document ';
EXECUTE IMMEDIATE' grant select on QAP_MS_VIEW to qry_lims';
end ;
but when i put the same statements in the procedure as mentioned below and try to execute the procedure it is giving an error insufficient privileges
command
CREATE OR REPLACE procedure qap_run_MT_View
as
BEGIN
EXECUTE IMMEDIATE 'drop materialized view QAP_MS_VIEW';
EXECUTE IMMEDIATE 'create materialized view QAP_MS_VIEW as select * from QAP_document ';
EXECUTE IMMEDIATE' grant select on QAP_MS_VIEW to qry_lims';
END;
/
please any one can advise
thanks
|
|
|
|
|
Re: executing Procedure problem [message #7872 is a reply to message #7871] |
Mon, 14 July 2003 05:36 |
Abu Arbab
Messages: 13 Registered: June 2003
|
Junior Member |
|
|
Hi MHE
I am executing procedure from the same schema which is the owner of the procedure. other procedures are working fine but I am not executing any ddl thu the procedure.
Thanks
|
|
|
|