Oracle WebCenter Content (MOSC)

MOSC Banner

Getting error while calling the Package

edited Sep 15, 2016 5:00AM in Oracle WebCenter Content (MOSC) 2 commentsAnswered

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"); 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center