Edit D:\app\Administrator\product\11.2.0\dbhome_1\olap\api\doc\oracle\express\spl\SPLExecutor.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <!--NewPage--> <HTML> <HEAD> <!-- Generated by javadoc (build 1.5.0_17) on Wed Aug 12 19:50:18 UTC 2009 --> <TITLE> SPLExecutor (Oracle OLAP Java API Reference) </TITLE> <META NAME="keywords" CONTENT="oracle.express.spl.SPLExecutor class"> <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../stylesheet.css" TITLE="Style"> <SCRIPT type="text/javascript"> function windowTitle() { parent.document.title="SPLExecutor (Oracle OLAP Java API Reference)"; } </SCRIPT> <NOSCRIPT> </NOSCRIPT> </HEAD> <BODY BGCOLOR="white" onload="windowTitle();"> <!-- ========= START OF TOP NAVBAR ======= --> <A NAME="navbar_top"><!-- --></A> <A HREF="#skip-navbar_top" title="Skip navigation links"></A> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> <TR> <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A NAME="navbar_top_firstrow"><!-- --></A> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR> </TABLE> </TD> <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> <b>Oracle® OLAP Java API Reference<br>11<i>g</i> Release 2 (11.2)</b><br>E10794-01<br>Beta Draft</EM> </TD> </TR> <TR> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl"><B>PREV CLASS</B></A> NEXT CLASS</FONT></TD> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../index.html?oracle/express/spl/SPLExecutor.html" target="_top"><B>FRAMES</B></A> <A HREF="SPLExecutor.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--> </SCRIPT> <NOSCRIPT> <A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A> </NOSCRIPT> </FONT></TD> </TR> <TR> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD> </TR> </TABLE> <A NAME="skip-navbar_top"></A> <!-- ========= END OF TOP NAVBAR ========= --> <HR> <!-- ======== START OF CLASS DATA ======== --> <H2> <FONT SIZE="-1"> oracle.express.spl</FONT> <BR> Class SPLExecutor</H2> <PRE> java.lang.Object <IMG SRC="../../../resources/inherit.gif" ALT="extended by "><B>oracle.express.spl.SPLExecutor</B> </PRE> <HR> <DL> <DT><PRE>public class <B>SPLExecutor</B><DT>extends java.lang.Object</DL> </PRE> <P> An object that accepts a <code>String</code> and sends it to Oracle OLAP for internal execution or evaluation. <p> Using an <code>SPLExecutor</code>, an application can execute a command in 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. <p> Depending on the evaluation method that you use, the return value of the method is a <code>boolean</code>, <code>int</code>, <code>double</code>, or other data type. An executed command always returns a <code>String</code>. The length of the <code>String</code> returned by the <CODE>executeCommand</CODE> method is limited to 4,000 single-byte characters. <p> For more information about the DML, see the <I>Oracle OLAP DML Reference</I>. <P> <P> <HR> <P> <!-- ======== CONSTRUCTOR SUMMARY ======== --> <A NAME="constructor_summary"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> <B>Constructor Summary</B></FONT></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#SPLExecutor(oracle.jdbc.OracleConnection)">SPLExecutor</A></B>(oracle.jdbc.OracleConnection connection)</CODE> <BR> Creates a new <code>SPLExecutor</code> object.</TD> </TR> </TABLE> <!-- ========== METHOD SUMMARY =========== --> <A NAME="method_summary"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> <B>Method Summary</B></FONT></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> boolean</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateBooleanExpression(java.lang.String)">evaluateBooleanExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML BOOLEAN expression, which Oracle OLAP evaluates, and returns the result as a <code>boolean</code>.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Date</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateDateExpression(java.lang.String)">evaluateDateExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML DATE expression, which Oracle OLAP evaluates, and returns the result as a <code>Date</code>.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> double</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateDecimalExpression(java.lang.String)">evaluateDecimalExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML DECIMAL, and returns the result as an <code>double</code> value.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> int</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateIntegerExpression(java.lang.String)">evaluateIntegerExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML INTEGER, and returns the result as an <code>int</code> value.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> float</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateShortDecimalExpression(java.lang.String)">evaluateShortDecimalExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML SHORTDECIMAL, and returns the result as an <code>float</code> value.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> short</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateShortIntegerExpression(java.lang.String)">evaluateShortIntegerExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML SHORTINTEGER, and returns the result as an <code>short</code> value.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.String</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateStringExpression(java.lang.String)">evaluateStringExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML TEXT expression, which Oracle OLAP evaluates, and returns the result as a <code>String</code>.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.String[]</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#evaluateStringListExpression(java.lang.String)">evaluateStringListExpression</A></B>(java.lang.String expr)</CODE> <BR> Interprets <code>expr</code> as a DML TEXT expression, which Oracle OLAP evaluates, and returns the result as an array of <code>String</code> objects.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.String</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#executeCommand(java.lang.String)">executeCommand</A></B>(java.lang.String command)</CODE> <BR> Interprets <code>command</code> as a DML command, which Oracle OLAP executes, and returns the result of the command.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../oracle/express/spl/SPLExecutor.html#initialize()">initialize</A></B>()</CODE> <BR> Initializes the <code>SPLExecutor</code>.</TD> </TR> </TABLE> <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"> <TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD><CODE>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD> </TR> </TABLE> <P> <!-- ========= CONSTRUCTOR DETAIL ======== --> <A NAME="constructor_detail"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> <B>Constructor Detail</B></FONT></TH> </TR> </TABLE> <A NAME="SPLExecutor(oracle.jdbc.OracleConnection)"><!-- --></A><H3> SPLExecutor</H3> <PRE> public <B>SPLExecutor</B>(oracle.jdbc.OracleConnection connection)</PRE> <DL> <DD>Creates a new <code>SPLExecutor</code> object. After creating an <code>SPLExecutor</code>, call its <code>initialize</code> method. <P> <DL> <DT><B>Parameters:</B><DD><CODE>connection</CODE> - The <CODE>oracle.jdbc.OracleConnection</CODE> that you used to connect to the Oracle Database.</DL> </DL> <!-- ============ METHOD DETAIL ========== --> <A NAME="method_detail"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> <B>Method Detail</B></FONT></TH> </TR> </TABLE> <A NAME="initialize()"><!-- --></A><H3> initialize</H3> <PRE> public void <B>initialize</B>() throws java.sql.SQLException</PRE> <DL> <DD>Initializes the <code>SPLExecutor</code>. Always call this method after creating a new <code>SPLExecutor</code> object. This method throws a <code>java.sql.SQLException</code> if an error occurs when OLAP OLAP is preparing for its OLAP DML interactions. <P> <DD><DL> <DT><B>Throws:</B> <DD><CODE>java.sql.SQLException</CODE></DL> </DD> </DL> <HR> <A NAME="executeCommand(java.lang.String)"><!-- --></A><H3> executeCommand</H3> <PRE> public java.lang.String <B>executeCommand</B>(java.lang.String command) throws <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>command</code> as a DML command, which Oracle OLAP executes, and returns the result of the command. The length of the <code>String</code> returned by this method is limited to 4,000 single-byte characters. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>command</CODE> - A <code>String</code> containing the DML command to execute. <DT><B>Returns:</B><DD>A <code>String</code> containing the execution 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 <code>String</code>. If the command was unsuccessful, then the <code>String</code> contains the resulting error report. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateIntegerExpression(java.lang.String)"><!-- --></A><H3> evaluateIntegerExpression</H3> <PRE> public int <B>evaluateIntegerExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML INTEGER, and returns the result as an <code>int</code> value. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a numeric expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>int</code> value to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateShortIntegerExpression(java.lang.String)"><!-- --></A><H3> evaluateShortIntegerExpression</H3> <PRE> public short <B>evaluateShortIntegerExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML SHORTINTEGER, and returns the result as an <code>short</code> value. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a numeric expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>short</code> value to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateDecimalExpression(java.lang.String)"><!-- --></A><H3> evaluateDecimalExpression</H3> <PRE> public double <B>evaluateDecimalExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML DECIMAL, and returns the result as an <code>double</code> value. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a numeric expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>double</code> value to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateShortDecimalExpression(java.lang.String)"><!-- --></A><H3> evaluateShortDecimalExpression</H3> <PRE> public float <B>evaluateShortDecimalExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML numeric expression, which Oracle OLAP evaluates as a DML SHORTDECIMAL, and returns the result as an <code>float</code> value. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a numeric expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>float</code> value to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateStringExpression(java.lang.String)"><!-- --></A><H3> evaluateStringExpression</H3> <PRE> public java.lang.String <B>evaluateStringExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML TEXT expression, which Oracle OLAP evaluates, and returns the result as a <code>String</code>. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a TEXT expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>String</code> to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateStringListExpression(java.lang.String)"><!-- --></A><H3> evaluateStringListExpression</H3> <PRE> public java.lang.String[] <B>evaluateStringListExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML TEXT expression, which Oracle OLAP evaluates, and returns the result as an array of <code>String</code> objects. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a TEXT expression by Oracle OLAP. <DT><B>Returns:</B><DD>The array of <code>String</code> objects to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateBooleanExpression(java.lang.String)"><!-- --></A><H3> evaluateBooleanExpression</H3> <PRE> public boolean <B>evaluateBooleanExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML BOOLEAN expression, which Oracle OLAP evaluates, and returns the result as a <code>boolean</code>. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a BOOLEAN expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>boolean</code> value to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <HR> <A NAME="evaluateDateExpression(java.lang.String)"><!-- --></A><H3> evaluateDateExpression</H3> <PRE> public java.util.Date <B>evaluateDateExpression</B>(java.lang.String expr) throws <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A>, <A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A>, <A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></PRE> <DL> <DD>Interprets <code>expr</code> as a DML DATE expression, which Oracle OLAP evaluates, and returns the result as a <code>Date</code>. <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>expr</CODE> - A <code>String</code> that can be interpreted as a DATE expression by Oracle OLAP. <DT><B>Returns:</B><DD>The <code>Date</code> to which the expression evaluated. <DT><B>Throws:</B> <DD><CODE><A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl">NAValueException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ObjectClosedException.html" title="class in oracle.express">ObjectClosedException</A></CODE> <DD><CODE><A HREF="../../../oracle/express/ExpressServerException.html" title="class in oracle.express">ExpressServerException</A></CODE></DL> </DD> </DL> <!-- ========= END OF CLASS DATA ========= --> <HR> <!-- ======= START OF BOTTOM NAVBAR ====== --> <A NAME="navbar_bottom"><!-- --></A> <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> <TR> <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A NAME="navbar_bottom_firstrow"><!-- --></A> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR> </TABLE> </TD> <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> <center>Copyright © 2002, 2009, Oracle. All rights reserved.</center></EM> </TD> </TR> <TR> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../oracle/express/spl/NAValueException.html" title="class in oracle.express.spl"><B>PREV CLASS</B></A> NEXT CLASS</FONT></TD> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../index.html?oracle/express/spl/SPLExecutor.html" target="_top"><B>FRAMES</B></A> <A HREF="SPLExecutor.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--> </SCRIPT> <NOSCRIPT> <A HREF="../../../allclasses-noframe.html"><B>All Classes</B></A> </NOSCRIPT> </FONT></TD> </TR> <TR> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD> </TR> </TABLE> <A NAME="skip-navbar_bottom"></A> <!-- ======== END OF BOTTOM NAVBAR ======= --> <HR> </BODY> </HTML>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de