Calling Stored Procedure from XSJS in XS Classic

[former_member604919]

Hi,

I am trying to call the stored proc from XSJS in XS Classic. This is my code:

var conn;
try {
	conn = $.hdb.getConnection();
	
	var fn = conn.loadProcedure("GUNAWF01", "ACCESS_TEST.FD.STORED_PROCEDURES::PR_050_HTS_SQL_TRAINd");
	//var fnResult = fn(searchStrategy);
	conn.commit();
	conn.close();
	$.response.setBody("Training finished.");
	$.response.status = $.net.http.OK;
	
} catch (err) {
    $.response.contentType = "text/plain";
    $.response.setBody("Error while executing query: [" + err.message + "]");
    $.response.returnCode = 200;
}

It looks like the stored procedure is never called. I got the message "Training Finished", but I don't see any output from the stored procedure. Not sure what is missing.

[thomas_jung · Accepted solution]

Well in the code above you have the call to the stored procedure commented out. Is that really what's in your service? If so that perfectly explains why the procedure isn't called. The loadProcedure just loads the metadata of the procedure and creates a JavaScript proxy function for it. You still have to call that function to execute the procedure.

[former_member604919 · Accepted solution]

Thanks Thomas for your help.

I figured it out how to call the procedure.

Regards

Ferry

[thomas_jung]

As I said above you have the actual call commented out (the // before that line).