Oracle-L: RE: ORACLE-Function problem

From: Babette Turner-Underwood <babette_at_rogers.com>
Date: Mon, 11 Nov 2002 07:43:28 -0800
Message-ID: <F001.0050013E.20021111074328@fatcity.com>

Had a similar problem recently where characterset on database differed than client.
We had to add NLS_CHARSET.zip (or was it .jar?) to the CLASSPATH.

Babette Turner-Underwood -----Original Message----- From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Savita Sent: Monday, November 11, 2002 2:33 AM To: Multiple recipients of list ORACLE-L Subject: ORACLE-Function problem

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 <=(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: Babette Turner-Underwood
INET: babette_at_rogers.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 - 09:43:28 CST