RE: ORACLE-Function problem

[Babette Turner-Underwood]

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