Shulou(Shulou.com)06/01 Report--

Platform: windows

Original library version: oracle 11.2.0.1

New library version: oracle 11.2.0.4

Upgrade method: software upgrade

After upgrading to 11.2.0.4 through the software, when the query statement involves more blob and clob fields, ORA-06550 and PLS-00306 will be reported: the number or type of parameters are incorrect when calling 'SYNCRN'. This problem is a bug problem, which can be solved by the following methods:

Log in to the database with plsql, and then complete the following two steps. Note that the two steps need to be completed under the same window:

(1) alter session set current_schema=CTXSYS

(2) recompile the following stored procedure:

Create or replace procedure syncrn (

Ownid IN binary_integer

Oname IN varchar2

Idxid IN binary_integer

Ixpid IN binary_integer

Rtabnm IN varchar2

Srcflg IN binary_integer

Smallr IN binary_integer

)

Authid definer

As external

Name "comt_cb"

Library dr$lib

With context

Parameters (

Context

Ownid ub4

Oname OCISTRING

Idxid ub4

Ixpid ub4

Rtabnm OCISTRING

Srcflg ub1

Smallr ub1

);

/

After the above steps are completed, the error reporting problem can be solved.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.