1 Reply Latest reply on Mar 16, 2016 4:19 AM by qngo RSS
    arunkumar Explorer

    Output type for SQL Insert

    Hi,

     

    I've created an SQL query service and added insert statement.

     

    Though the insert statement successfully runs, I get "Unable to Invoke Service TestSQLInsert on MyDBThing : null".

     

    The default Output type is INFOTABLE. Even after changing this output type to Long or anything, I get the same error.

     

    What is the correct output type I should use? Is it right to have INSERT/UPDATE statements in SQL Query service? If not what is the approach I should use for writing INSERT/UPDATE statements.

     

    Regards

    Arunkumar D