IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Invalid SQL Statement

    Posted Fri July 22, 2005 10:26 PM

    I m trying to run the following SQL statement:

    slc_hrinf_int_summary_pkg.create_int_summary_record(‘HR105’,4032527,sysdate,sysdate)

    I m getting the following error :

    lastError/error=“java.sql.SQLExceptionRA-00900: invalid SQL statement”

    $dbSQL=“slc_hrinf_int_summary_pkg.create_int_summary_record( ‘HR105a’,4032527,sysdate,sysdate)”

    Any Help will be appreciated


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 2.  RE: Invalid SQL Statement

    Posted Sun July 24, 2005 12:45 AM

    The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. Correct the syntax or install the Procedural Option.

    HTH


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


Related Content