Hi..

I have a function which has input parameter as long and returns long.

The function executes correctly without any issues.But when i call this function in a select statement, it says ORA-00997: illegal use of LONG datatype

eg:

Code:
Table | column | Dataype 
 ------------------------
 Emp  |  addr   |  Long

Code:
Function : 
---------
FUNCTION TRANSL_LONG(p_string LONG )
RETURN LONG;
when i do

Code:
select transl_long(addr) from Emp;
i get the error . <ORA-00997: illegal use of LONG datatype>

Also i tried changing the return type of the function to CLOB.Still i get the same error.

Please help me on this.Also i dont want to change the datape from long to clob in the table due to some constraints in my application side.