Error while executing Store procedure

[jainmnsh]

Hi Guys,

I am able open the connection and able to execute the sql fine but when I am trying to execute the procedure, its just returning very generic message. any help will be appreciate..

Error: ORA-00900: invalid SQL statement

below is my code. sql = "EXECUTE xxxxx ( '2022', :1 );"; // callback(null, 'Success'); oracle.connect(connString, function (err, connection) { if (err) { logger.error('connection Error ' + err); callback(err, null); } else { logger.debug('connection success'); connection.execute(sql, [new oracle.OutParam(oracle.OCCICURSOR)], function (err, results) { if (err) { logger.error('Error in execution of SP' + err); connection.close(); } else { connection.close(); logger.debug('Results ' + JSON.stringify(results)); callback(null, results); }

        });
    }

});

[cjbj]

EXECUTE is a SQL*Plus client command. It's not part of SQL or PL/SQL. Try using a BEGIN END block.