Common Errors - Invoking Oracle Stored procedure from MuleSoft 4.0 - DateTime formats and Default values
Introduction : In Mule implementation, a common mistake while invoking Oracle's stored procedure is, incorrectly defining the order of IN/OUT parameters. These IN and OUT parameters data types and format should match with Oracle DB stored procedure's definition. Problem Statement : I have recently come across a scenario, where I need to invoke Oracle's DB stored procedure from Mule with IN/OUT parameters. out of which couple of fields are having Date as datatype. During the invocation, there were some errors appeared which is little tricky to understand, however, the root cause was incorrect format of the input Date type parameter. I am taking a sample procedure and DB table mentioned below to illustrate the error scenarios with Oracle DB Procedure call and their possible solution. Database table structure : Oracle DB Procedure : XX_TEST_CREATE_ORDER CREATE OR REPLACE PROCEDURE xx_test_create_order i_orderid IN NUMBER, ...