Is there any method to get summary of stored procedure execution on oracle database? I use a target method in stored procedure stage. My SP is just inserting data in a oracle table. The most valuable information would be how many records were succesfully inserted into oracle table.
Thanks in advance.
Best regards,
Piotrek
info about Stored Procedure execution
Moderators: chulett, rschirm, roy
Hi,
If your SP stage doesn't have output parameters I doubt you can get it on a per row basis while you write them in DS.
What you can do is have your SP handle an Audit table That you can later examine and analyze to death.
May I ask why are you inserting dat via a SP in the first place?
Any logic can be implemented via DS as well.
IHTH,
If your SP stage doesn't have output parameters I doubt you can get it on a per row basis while you write them in DS.
What you can do is have your SP handle an Audit table That you can later examine and analyze to death.
May I ask why are you inserting dat via a SP in the first place?
Any logic can be implemented via DS as well.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Hi,
It was just an example of a SP. I was wondering about capabilities in making some logs while using SP stage.
I know that it could be easily implemented via DS, but our company's customer is using some SP's to upsert data to oracle and there is a possibility that he won't agree to stop using that.
What do you mean by saying 'per row basis' and 'SP handle an Audit table'?
Regards,
Piotrek
It was just an example of a SP. I was wondering about capabilities in making some logs while using SP stage.
I know that it could be easily implemented via DS, but our company's customer is using some SP's to upsert data to oracle and there is a possibility that he won't agree to stop using that.
What do you mean by saying 'per row basis' and 'SP handle an Audit table'?
Regards,
Piotrek