Invalid SQL Statement

, ,
1

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

2

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