ORA-00997 illegal use of LONG datatypeCause: A value of datatype LONG was used in a function or in a DISTINCT,
WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in
a SELECT clause.Action: Remove the LONG value from the function or clause.不能把Long类型作为函数的参数。
WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in
a SELECT clause.Action: Remove the LONG value from the function or clause.不能把Long类型作为函数的参数。
r IN RAW)
RETURN VARCHAR2;参考:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_raw2.htm#1000586