Re: ORACLE-Function problem

Hi justin,

Thanks for the help,actually this query will send to an XML Processore and <
will replaced with <.But my problem was something else.I have resolved that problem now.

Thanks once again for the help.

Justin Cave wrote:

> 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 &lt;=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2))
> >ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID);
>
> Do you intend for the "&lt;" 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).

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Savita
  INET: savita_at_india.hp.com

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).