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.
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