Skip to Content
1
Former Member
Feb 04, 2014 at 01:31 PM

Procedure Call from .xsjs: Nothing happens in database

34 Views


Dear all,

I want to call a procedure from an .xsjs file by the following code:

// Executing the call


var conn = $.db.getConnection();
var cst = conn.prepareCall("CALL \"_SYS_BIC\".\"Sentiment_Analysis.models/analyze_messages_v2\"()");
cst.execute();

// Displaying "Hello World" in the browser


$.response.contentType = "text/plain";
$.response.setBody( "Hello, World !");

cst.close();
conn.close();

"Hello World" is displayed in the browser. The procedure should calculate sentiments and write the results in a table. However, nothing changes in the result table in the database.

The procedure has no input or output parameters. When called from the SQLConsole within the HANA Studio, everything works fine. Does anyone see what I am missing?

Cheers

Florian