[20150707]ORA-00932.txt

[20150707]ORA-00932: inconsistent datatypes: expected - got CLOB.txt

--自己写一个通过sql_id查看sql语句的脚本：

column sqltext format a200
select sql_id,replace(sql_fulltext,chr(13),'') sqltext  from v$sql where  sql_id = '&&1' and rownum<=1
union
select sql_id,replace(sql_text,chr(13),'') sqltext  from dba_hist_sqltext where  sql_id = '&&1' and rownum<=1;

--出现如下错误：
              *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got CLOB

--修改如下ok：

$ cat sqlid.sql
column sql_fulltext format a160
column sqltext format a200

select sql_id,to_char(replace(sql_fulltext,chr(13),'')) sqltext  from v$sql where  sql_id = '&&1' and rownum<=1
union
select sql_id,to_char(replace(sql_text,chr(13),'')) sqltext  from dba_hist_sqltext where  sql_id = '&&1' and rownum<=1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-1725167/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-1725167/