The problem is the first space before CALL SQL.
Hope that helps.
Walt
> Hi
> I am trying to use CALL SQL
>
> I get following exception with the code below
> Exception -- Failed to query objects!: An incorrect token type was found
> near CALL (2, need 1
>
> Code:
> QueryResults queryResults;
> Object resultObj;
> OQLQuery oqlQuery = _db.getOQLQuery( " CALL SQL SELECT ID,
> ATTRIBUTE_DEFINITION_ID, VALUE, OBJECT_ID FROM ATTRIBUTE " );
> queryResults = oqlQuery.execute();
> while ( queryResults.hasMore() ) {
> resultObj = queryResults.next();
> results.add(resultObj);
> }
>
> Where is the problem in code ?
>
> Thanks
> Abhay
>
*****************************************************
Walter Szewelanczyk
IS Director
M.W. Sewall & CO. email : [EMAIL PROTECTED]
259 Front St. Phone : (207) 442-7994 x 128
Bath, ME 04530 Fax : (207) 443-6284
*****************************************************
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
