oracle.apps.fnd.applcore.flex.common.sql
Class SQLUtils

java.lang.Object
  oracle.apps.fnd.applcore.flex.common.sql.SQLUtils

public class SQLUtils
extends java.lang.Object

Constructor Summary

SQLUtils()

Method Summary

static void

validateSQLSelectStatement(java.lang.String sql, oracle.jbo.ApplicationModule am) Validates the syntax of the SQL select statement.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLUtils

public SQLUtils()

Method Detail

validateSQLSelectStatement

public static void validateSQLSelectStatement(java.lang.String sql,
                                              oracle.jbo.ApplicationModule am)

Validates the syntax of the SQL select statement. If the SQL contains bind variables, they must use either the Oracle Named or Positional syntax; JDBC Positional syntax using the question mark as a placeholder is not supported.

Parameters:

sql - the SQL select statement to validate

am - the Application Module from which to get the database connection

Throws:

oracle.jbo.SQLStmtException - if there is an error in the SQL syntax