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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).