// Open a connection var myConn = database.connect("ORACLE", "mySID", "myApp", "appsPWD", "myTNS"); myConn.beginTransaction(); // Run the stored procedure var myStproc = myConn.storedProc("sp_employees"); // Write the output parameters of this stored procedure to the // user's page. for(var i = 0; i <= myStproc.outParamCount(); i++){ write(myStproc.outParameters(i) + '
'); } // Close the result set myStproc.close(); // Commit the transaction myConn.commitTransaction();