I have two procedures which need to run one by one based time scheduled in table and I need to pass the parameters from database table for these procedures which is received from asp.net application then I need to update the procedure status to the same table as 'Schedule','Running','Error' when I got Error I need to store the error message to the table.
Please help me on this
The tags are meaningless, your post doesn't get moved to the correct forum if you add SQL and PL/SQL as tags. If you want to post to the SQL and PL/SQL Forum then you have to go over there and post there. Check out the link Hamid provided you.