阅读背景:

clob变量值无法使用v$sql_bind_capture获得

来源:互联网 

clob情形:
SQL> variable test_c clob;
SQL> exec :test_c := "test";

PL/SQL procedure successfully completed.

SQL> select * from test_clob where dbms_lob.substr(name,4000)=dbms_lob.substr(:test_c,4000);

NAME
--------------------------------------------------------------------------------
test

SQL> select sql_id,sql_text from v$sql where sql_text like "select * from test_clob%";
65v08jhcjtuun
select * from test_clob where dbms_lob.substr(name,4000)=dbms_lob.substr(:test_c
,4000)


SQL> select value_string from v$sql_bind_capture where sql_id="65v08jhcjtuun";

VALUE_STRING
clob情形:
SQL> variable test_c clob;
SQL> exec :test




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: