|
Oracle OLAP Java API Reference 10g Release 1 (10.1) B10994-01 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.express.spl.SPLExecutor
An object that accepts a String
and sends it to Oracle OLAP for internal execution or evaluation.
Using an SPLExecutor
, an application can execute a command in an the OLAP Data Manipulation Language (DML), which is also referred to as a Stored Procedure Language (SPL). Alternatively, an application can evaluate an expression in that language.
Depending on the evaluation method that you use, the return value of the method is a boolean
, int
, double
, or other data type. An executed command always returns a String
.
For more information about the DML, see the Oracle OLAP DML Reference.
Constructor Summary | |
SPLExecutor(oracle.jdbc.OracleConnection connection) Creates a new SPLExecutor object. |
Method Summary | |
boolean |
evaluateBooleanExpression(java.lang.String expr) Interprets the String specified in expr as a DML BOOLEAN expression, evaluates it in Oracle OLAP, and returns the result as a boolean value. |
java.util.Date |
evaluateDateExpression(java.lang.String expr) Interprets the String specified in expr as a DML DATE expression, evaluates it in Oracle OLAP, and returns the result as a Date . |
double |
evaluateDecimalExpression(java.lang.String expr) Interprets the String specified in expr as a DML numeric expression, evaluates it in Oracle OLAP to a DML DECIMAL, and returns the result as a double value. |
int |
evaluateIntegerExpression(java.lang.String expr) Interprets the String specified in expr as a DML numeric expression, evaluates it in Oracle OLAP as a DML INTEGER, and returns the result as an int value. |
float |
evaluateShortDecimalExpression(java.lang.String expr) Interprets the String specified in expr as a DML numeric expression, evaluates it in Oracle OLAP as a DML SHORTDECIMAL, and returns the result as a float value. |
short |
evaluateShortIntegerExpression(java.lang.String expr) Interprets the String specified in expr as a DML numeric expression, evaluates it in Oracle OLAP to a DML SHORTINTEGER, and returns the result as a short value. |
java.lang.String |
evaluateStringExpression(java.lang.String expr) Interprets the String specified in expr as a DML TEXT expression, evaluates it in Oracle OLAP, and returns the result as a String . |
java.lang.String[] |
evaluateStringListExpression(java.lang.String expr) Interprets the String specified in expr as a DML TEXT expression, evaluates it in Oracle OLAP, and returns the result as an array of String objects. |
java.lang.String |
executeCommand(java.lang.String command) Interprets the String specified in command as a DML command, executes it in Oracle OLAP, and returns the result of the command. |
void |
initialize() Initializes the SPLExecutor . |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public SPLExecutor(oracle.jdbc.OracleConnection connection)
SPLExecutor
object. After creating an SPLExecutor
, call its initialize method.connection
- The oracle.jdbc.OracleConnection
that you used to connect to the Oracle database.Method Detail |
public void initialize() throws java.sql.SQLException
SPLExecutor
. Always call this method after creating a new SPLExecutor
object. This method throws a java.sql.SQLException
if an error occurs when OLAP OLAP is preparing for its OLAP DML interactions.public java.lang.String executeCommand(java.lang.String command) throws ObjectClosedException, ExpressServerException
String
specified in command
as a DML command, executes it in Oracle OLAP, and returns the result of the command.command
- A String
containing the DML command to execute.String
containing the exectution log that results from the execution of the specified DML command. If the command was successful, then the log contains the return value of the command as a String
. If the command was unsuccessful, then the String
contains the resulting error report.public int evaluateIntegerExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML numeric expression, evaluates it in Oracle OLAP as a DML INTEGER, and returns the result as an int
value.expr
- A String
that can be interpreted as a numeric expression by Oracle OLAP.int
value to which the expression evaluated.public short evaluateShortIntegerExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML numeric expression, evaluates it in Oracle OLAP to a DML SHORTINTEGER, and returns the result as a short
value.expr
- A String
that can be interpreted as a numeric expression by Oracle OLAP.short
value to which the expression evaluated.public double evaluateDecimalExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML numeric expression, evaluates it in Oracle OLAP to a DML DECIMAL, and returns the result as a double
value.expr
- A String
that can be interpreted as a numeric expression by Oracle OLAP.double
value to which the expression evaluated.public float evaluateShortDecimalExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML numeric expression, evaluates it in Oracle OLAP as a DML SHORTDECIMAL, and returns the result as a float
value.expr
- A String
that can be interpreted as a numeric expression by Oracle OLAP.float
value to which the expression evaluated.public java.lang.String evaluateStringExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML TEXT expression, evaluates it in Oracle OLAP, and returns the result as a String
.expr
- A String
that can be interpreted as a TEXT expression by Oracle OLAP.String
to which the expression evaluated.public java.lang.String[] evaluateStringListExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML TEXT expression, evaluates it in Oracle OLAP, and returns the result as an array of String
objects.expr
- A String
that can be interpreted as a TEXT expression by Oracle OLAP.String
objects to which the expression evaluated.public boolean evaluateBooleanExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML BOOLEAN expression, evaluates it in Oracle OLAP, and returns the result as a boolean
value.expr
- A String
that can be interpreted as a BOOLEAN expression by Oracle OLAP.boolean
value to which the expression evaluated.public java.util.Date evaluateDateExpression(java.lang.String expr) throws NAValueException, ObjectClosedException, ExpressServerException
String
specified in expr
as a DML DATE expression, evaluates it in Oracle OLAP, and returns the result as a Date
.expr
- A String
that can be interpreted as a DATE expression by Oracle OLAP.Date
to which the expression evaluated.
|
Oracle OLAP Java API Reference 10g Release 1 (10.1) B10994-01 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |