Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 27 May 2016

Outbound Interfaces

Share this article :

2 comments:

  1. Hi There,


    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).

    Many Thanks,
    Vimala

    ReplyDelete
  2. Hi There,

    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

    Once again thanks for your tutorial.

    Best Regards,
    Preethi.

    ReplyDelete