Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORACLE-Function problem

ORACLE-Function problem

From: Savita <savita_at_india.hp.com>
Date: Sun, 10 Nov 2002 23:33:24 -0800
Message-ID: <F001.004FFD35.20021110233324@fatcity.com>


Hi All,

I have a problem executing the function in oracle through JDBC.

I have written a select statement inside which I am calling a function. The query is something like

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

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)

--

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). Received on Mon Nov 11 2002 - 01:33:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US