Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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
--
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 servicesto: 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
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message