Brilliant article, glad I slogged through the Inventory Outbound Interface it seems that a whole lot of the details really come back to from my past project.
Please, can you advise me on this query if it is correct? I have been asked to produce a report of vacation by staff for the year 2017 and group by line manager. The question is looking at this query, I have ordered by line manager which I think is showing staff under each manager but I am not sure If I need to break on the line manager and how to accomplish this. Please note that I inherited these table definitions.
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Grazie! Grazie! Grazie! Your blog is indeed quite interesting around Outbound Interfaces 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
Hi There,
ReplyDeleteBrilliant article, glad I slogged through the Inventory Outbound Interface it seems that a whole lot of the details really come back to from my past project.
Please, can you advise me on this query if it is correct? I have been asked to produce a report of vacation by staff for the year 2017 and group by line manager. The question is looking at this query, I have ordered by line manager which I think is showing staff under each manager but I am not sure If I need to break on the line manager and how to accomplish this. Please note that I inherited these table definitions.
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Many Thanks,
Vimala
Hi There,
ReplyDeleteGrazie! Grazie! Grazie! Your blog is indeed quite interesting around Outbound Interfaces 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,
Preethi.