// Assign the user submitted ID and name to the client object as properties client.uid = request.uid; client.name = request.name; // Open a connection var myConn = database.connect("ORACLE", "mySID", "myApp", "appsPWD", "myTNS", true); if(myConn.connected()){ // Start a new SQL transaction to perform a SELECT myConn.beginTransaction(); var currRow = myConn.cursor('SELECT * FROM employees WHERE uid = ' + client.uid); // Focus on that line, change the name column for that user, // and update the row. currRow.next(); currRow.name = client.name; currRow.updateRow("employees"); myConn.commitTransaction(); // Close the cursor and the connection currRow.close(); myConn.disconnect(); // If the connection fails, write an error message }else{ write('Error (' + myConn.majorErrorCode() + '): ' + myConn.majorErrorMessage); }