Stored Procedure
Posted: Thu Sep 06, 2007 2:09 am
Hi,
I have one stored procedure in Oracle to refresh all the materialized views in the schema. This stored procedure takes no input. when i execute the job i am getting the following error "Active Stage has no inputs or outputs".
I don't wnat to execute in sqlprompt or call sqlplus from routines.
Pls. do let me know how to go with the job.
I have one stored procedure in Oracle to refresh all the materialized views in the schema. This stored procedure takes no input. when i execute the job i am getting the following error "Active Stage has no inputs or outputs".
I don't wnat to execute in sqlprompt or call sqlplus from routines.
Pls. do let me know how to go with the job.