CLOB problem [message #38298] |
Mon, 08 April 2002 23:24 |
Aditi Das
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
I am trying to return a cursor to my java program from the oracle function which I have coded.
In my function the syntax I wrote was:
OPEN MYCUR FOR
SELECT CD_PT_TEXT,USE_ID FROM CD_PT_TMP
WHERE USE_ID = v_user;
RETURN MYCUR;
Here the datatype of CD_PT_TEXT field is CLOB.
When I am trying to compile the function the error shows:
"PLS-00382: expression is of wrong type."
The Cause and the action which it gives is:
Cause:
------
An expression has the wrong datatype for the context in which it was found.
Action:
-------
Change the datatype of the expression. You might want to use datatype conversion functions.
Can you give me the reason why?
What has to be done in such cases?
|
|
|
Re: CLOB problem [message #38552 is a reply to message #38298] |
Fri, 26 April 2002 04:48 |
Saga
Messages: 51 Registered: April 2002
|
Member |
|
|
U can't use CLOB in ref_cursors try using a varchar2. I doubt if it will work even with LONG datatype.
Hope it helps
|
|
|