Getting error while calling the Package
Hi,
I am getting error as "Oracle not defined at nashorn:mozilla_compat.js"
We imported " importPackage(oracle.jdbc.OracleDriver());
Below is the code passing cursor in the DBcall function
var conn = java.sql.DriverManager.getConnection(url,UserName,Pass);
print("conn " + conn + "\n");
stmt = conn.prepareCall("{call PKG_SAM_ASSIGN_TEST_EC(?,?)}");
print("stmt " + stmt + "\n");
stmt.setString(1, "DEV");
print("stmt1 " + stmt + "\n");
stmt.registerOutParameter(2, OracleTypes.CURSOR);
print("stmt2 " + stmt + "\n");
stmt.execute();
print("stmt3 " + stmt + "\n");
var rs = stmt.getObject(2);
print("Result Set Inside " + rs + "\n");
while (rs.next()) {
s = rs.getString("v_offset");
print("Result Set out side " + s + "\n");