This is indeed great! But I think perhaps you are generally referring #topic which is getting Unsustainable.
I need some help from you experts on this stored procedure..
There are 4-5 batch procedures that will call this stored procedure. The batch will call the stored procedure with 'I' parameter in the beginning of the batch process. The batch will call the stored procedure with 'O' parameter at the end of the batch process. The stored procedure should write the details into the auditing table. But great job man, do keep posted with the new updates.
Grazie! Grazie! Grazie! Your blog is indeed quite interesting around Mindsforest I agree with you on lot of points!
I posted before regarding using oracle UDT stored procedure parameter type to pass a list of records for multiple insert using .net c#. I had the below example where a class definition is needed at .net side to map to oracle object. Unfortunately, I did not apply this due to the extra mapping code that is needed. http://appsjack.blogspot.com.eg/2010/09/pass-custom-udt-types-to-oracle-stored.html
My question is: did this change with oracle 12c? Can we now use:
parameter.UdtTypeName = directOracleUDTName; //without the need for .net definition and mapping classes
Greetings Mate,
ReplyDeleteThis is indeed great! But I think perhaps you are generally referring #topic which is getting
Unsustainable.
I need some help from you experts on this stored procedure..
There are 4-5 batch procedures that will call this stored procedure. The batch will call the stored procedure with 'I' parameter in the beginning of the batch process. The batch will call the stored procedure with 'O' parameter at the end of the batch process. The stored procedure should write the details into the auditing table.
But great job man, do keep posted with the new updates.
Shukran,
Szia,
ReplyDeleteGrazie! Grazie! Grazie! Your blog is indeed quite interesting around Mindsforest I agree with you on lot of points!
I posted before regarding using oracle UDT stored procedure parameter type to pass a list of records for multiple insert using .net c#.
I had the below example where a class definition is needed at .net side to map to oracle object. Unfortunately, I did not apply this due to the extra mapping code that is needed.
http://appsjack.blogspot.com.eg/2010/09/pass-custom-udt-types-to-oracle-stored.html
My question is: did this change with oracle 12c? Can we now use:
parameter.UdtTypeName = directOracleUDTName; //without the need for .net definition and mapping classes
Once again thanks for your tutorial.
Best Regards,
Radhey