Re: ORACLE-Function problem

At 12:33 AM 11/11/2002, you wrote:

>select
>OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID as CASE_MSG__OS_CASE_ID,
>OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUSTOMER_ID,
>OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUST_ID,
>OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID as CASE_MSG__OS_UNIT_ID,
>OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as CASE_MSG__CREATED_DATE,
>'OS_1' as CASE_MSG__UPDATED_BY
>FROM OSP_CRM_EXCHANGE_CASE_VIEW
>WHERE
>ROWNUM <=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2))
>ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID);

Do you intend for the "<" to be in the query? I'm not sure what you expect this to do, but I suspect that's your illegal character.

>here OSP_CRM_EXCHANGE_getMaxDataId(2) is the function.
>
>When I execute this query in command prompt Itis working fine,but when I
>use it insied a executeQueryStatement(query) in JDBC I am getting
>following error
>ORA-00911: invalid character
>
>I am not able to figure out how to modify this.
>
>Any help will be highly appriciated.
>
>--
>Best Regards
>- Savita
>----------------------------------------------------
>Hewlett Packard (India)
>+91 80 2051288 (Phone)
>847 1288 (HP Telnet)
>----------------------------------------------------
>

Justin Cave
Distributed Database Consulting

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).