I have created a stored procedure in oracle to refresh oracle materialized views, I turned to stored procedure because I was originally trying to do it in run sql after execution but it kept failing with invalid sql . No I have teh sored procedure and I have placed it in sqlExecutor to test and its still returning errors..
this is the oracle create procedure statement (names changed )
create or replace PROCEDURE "MYProcedure" AS
BEGIN
DBMS_MVIEW.REFRESH('A,B,C,D', method => 'F', atomic_refresh => FALSE );
END;
and this is how I try to execute it in sqlCreator
FME_SQL_DELIMITER /
begin
exec NBPNBICASPER_VIEW
end ;
/
This fails and the only way I get no error (but nothing runs ) is put : in front of the procedure name )
FME_SQL_DELIMITER /
begin
exec :NBPNBICASPER_VIEW
end ;
/
What am I doing wrong .. Have I gone about this incorrectly? any help direction etc. is hugely appreciated.
Paul