• notice
  • Congratulations on the launch of the Sought Tech site

ORA-06550 and PLS-00306 problems are reported after the database is upgraded

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, it will report ORA-06550, PLS-00306: The number or type of parameters is incorrect when calling'SYNCRN'.The problem is a The bug problem can be solved by the following methods:

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

(1)alter session set current_schema=CTXSYS;

(2) Recompile the following stored procedures:

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.


Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

buy lipitor 10mg without preion & lt;a href="https://lipiws.top/"& gt;atorvastatin 10mg brand& lt;/a& gt; order atorvastatin 40mg pill

Yjiqss

2024-03-08

Leave a Reply

+