About the Custom Procedure Examples Syntax
Developers creating procedures for execution on a UNIX or Linux operating system need to use colons (instead of semicolons) as separators. Also when using new line strings, for Windows it will be “/r/n” compared with Linux “/n”.
Regardless of the operating system, path names must use the forward slash. For example:
// Update in the first data source using a SQL statement
numRowsUpdated = qenv.executeUpdate(
"UPDATE /shared/tutorial/sources/ds_orders/customers" +
" SET ContactFirstName='" + inputValues[1] +
"', ContactLastName='" + inputValues[2] +
"', CompanyName='" + inputValues[3] +
"', PhoneNumber='" + inputValues[4] +
"' WHERE CustomerID=" + inputValues[0],
null);