(2 votes, average: 4.50 out of 5)
Loading ...I know that this is not a requirement that you will face everyday but I did face it and didn’t find anything useful on the web which could tell me exact script that I can use to trigger a stored procedure residing the database.
There are some questions that might cross you mind such as…
1. Why do I need execute a stored procedure on database?
Answer: There can be several requirements that might require you to do that but most common of all will be in case of data migration through EIM. For example:
You are getting data in EIM tables and you need to trigger EIM job to load that data from EIM tables to base tables (you might think easy, trigger an EIM job) but the catch here is that this data is not clean and there are duplicate record present which can result in your EIM process to fail.
You have created a stored procedure that can process this data and make it clean but how to do you trigger that stored procedure after data is loaded in EIM tables and before EIM Job is triggered?
2. Isn’t there any other way I can handle this?
Answer: The easiest way to handle this is to ask external application to provide clean 
data but that is seldom possible.
Handling it from within Siebel is going to increase complexity of solution a lot and also if you are thinking of handling it at business layer then you might introduce performance issue in your application while your process is running at database.
I think the best way to handle it at database layer and this approach is least intrusive and most stable.
Please do share if you have better idea or approach and ask any question that might come to your mind.
So, not wasting your time further below given link will provide you access to script to trigger a stored procedure at database.
Authors bio is coming up shortly.
Loading ...