Ошибка ora 06553 pls 306

I´m trying a query in oracle 10g. It goes like this:

SELECT
  *
FROM
  h2h_reg reg,
  h2h_cat_estatus est
WHERE
  reg.FECH_APLICACION = SYSDATE
AND REG.ID_EST        = EST.ID_ESTATUS
AND est.tipo_estatus  = "X";

So it runs smootly, but when I try it adding a group by:

SELECT
  reg.id_arch,
  reg.id_prod
FROM
  h2h_reg reg,
  h2h_cat_estatus est
WHERE
  reg.FECH_APLICACION = SYSDATE
AND reg.id_est        = est.id_estatus
AND EST.TIPO_ESTATUS  = "X"
GROUP BY
  reg.id_arch,
  reg.id_prod;

I get the next message:

ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’

Does anyone knows what´s wrong in my query?

Источник

While I call the procedure, it gives me error:

ORA-06553: PLS-306: wrong number or types of arguments in call to 'UPDATE_LETTER_BODY'

Here is my procedure code:

    CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY IS
    body_text varchar2(32767); 
    condition_id integer;
    begin    
        update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=body_text 
        where FKOL_OFFICEWISE_LETTER_ID=condition_id;
    end;

Here is how I called it:

     CALL UPDATE_LETTER_BODY('test',241);

asked Dec 19, 2012 at 7:09

hsuk's user avatar

3

Check this out : 

       CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY  ( body_text IN FMS_K_OFFICEWISE_LETTER.FKOL_LETTER_BODY%type,condition_id in FMS_K_OFFICEWISE_LETTER.FKOL_OFFICEWISE_LETTER_ID%type)IS
       begin
          update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY= body_text
          where FKOL_OFFICEWISE_LETTER_ID=condition_id;
       end;

answered Dec 20, 2012 at 5:46

user1917764's user avatar

0

It should be 

CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY(body_text in varchar2,condition_id in number) IS
begin    
    update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=body_text 
    where FKOL_OFFICEWISE_LETTER_ID=condition_id;
end;

answered Dec 19, 2012 at 7:13

Rahul Vasantrao Kamble's user avatar

CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY  ( body_text  IN varchar2,condition_id  in integer ) IS
begin    
    update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=body_text 
    where FKOL_OFFICEWISE_LETTER_ID=condition_id;
end;

update your proc as above …

answered Dec 19, 2012 at 7:25

Nipun Jain's user avatar

Nipun JainNipun Jain

6224 silver badges6 bronze badges

1

Источник

I´m trying a query in oracle 10g. It goes like this:

SELECT
  *
FROM
  h2h_reg reg,
  h2h_cat_estatus est
WHERE
  reg.FECH_APLICACION = SYSDATE
AND REG.ID_EST        = EST.ID_ESTATUS
AND est.tipo_estatus  = "X";

So it runs smootly, but when I try it adding a group by:

SELECT
  reg.id_arch,
  reg.id_prod
FROM
  h2h_reg reg,
  h2h_cat_estatus est
WHERE
  reg.FECH_APLICACION = SYSDATE
AND reg.id_est        = est.id_estatus
AND EST.TIPO_ESTATUS  = "X"
GROUP BY
  reg.id_arch,
  reg.id_prod;

I get the next message:

ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’

Does anyone knows what´s wrong in my query?

Источник

ORA-06553: PLS-306: wrong number or types of arguments in call to

ORA-06553: PLS-306: wrong number or types of arguments in call to

Cause:

An Oracle function was referenced with an incorrect number of arguments.

Solution:

Correct the syntax of the function by entering the required number of arguments.

Example:

create or replace function TEST(p_id number)
return varchar2 as
	v_name varchar2(250);
begin
	select name 
	into v_name 
	from employees 
	where id = p_id;
	return v_name;
end;

SELECT test(1,2) FROM dual;

Output:

ORA-06553: PLS-306: wrong number or types of arguments in call to ‘TEST’

Correct

SELECT test(1) FROM dual;
Источник

Steps:

1. Update OPatch and OMSPatcher in the Middleware Home. To update
OPatch, go to the Patch 6880880, and pick 13.9 release. To update OMSPatcher,
go to the Patch 19999993 and pick the correct Enterprise Manager release. 

2. Download
the patch 24914115 and apply the patch

3.
Restart OMS

1. Update OPatch and OMSPatcher in the Middleware Home

[oracle@cloud ~]$  export ORACLE_HOME=/opt/oracle/middleware_13.2

[oracle@cloud ~]$
/opt/oracle/middleware_13.2/OPatch/opatch version

OPatch Version:
13.8.0.0.0

OPatch succeeded.

[oracle@cloud ~]$
/opt/oracle/middleware_13.2/OMSPatcher/omspatcher version

OMSPatcher
Version: 13.8.0.0.0

OPlan Version:
12.1.0.2.2

OsysModel build:
Mon Dec 21 18:31:52 PST 2015

OMSPatcher
succeeded.

[oracle@cloud ~]$ cd /tmp/

[oracle@cloud tmp]$ mkdir downloadpatch

[oracle@cloud tmp]$ cd downloadpatch

Download Patch 6880880 and Patch 19999993

[oracle@cloud downloadpatch]$ wget —http-user=username
—http-password=pass —no-check-certificate —output-document=filename https://updates.oracle.com/Orion/Services/download/p6880880_139000_Generic.zip?aru=20781116&patch_file=p6880880_139000_Generic.zip

[oracle@cloud downloadpatch]$ wget —http-user=username
—http-password=pass —no-check-certificate —output-document=filename https://updates.oracle.com/Orion/Services/download/p19999993_132000_Generic.zip?aru=20713685&patch_file=p19999993_132000_Generic.zip

[oracle@cloud downloadpatch]$ ls

p19999993_132000_Generic.zip  p6880880_139000_Generic.zip

[oracle@cloud downloadpatch]$ unzip
p6880880_139000_Generic.zip

[oracle@cloud downloadpatch]$ ls

6880880  p19999993_132000_Generic.zip  p6880880_139000_Generic.zip

[oracle@cloud downloadpatch]$ cd 6880880

[oracle@cloud 6880880]$
/opt/oracle/middleware_13.2/oracle_common/jdk/bin/java -jar opatch_generic.jar
-silent ORACLE_HOME=/opt/oracle/middleware_13.2

[oracle@cloud 6880880]$ $OMS_HOME/OPatch/opatch
version

OPatch Version:
13.9.1.0.0

OPatch succeeded.

[oracle@cloud 6880880]$ cd $OMS_HOME

[oracle@cloud middleware_13.2]$ mv OMSPatcher
OMSPatcher.bak

[oracle@cloud middleware_13.2]$ unzip /tmp/downloadpatch
/p19999993_132000_Generic.zip -d $OMS_HOME

Archive:  /tmp/patch/p19999993_132000_Generic.zip

   creating:
/opt/oracle/middleware_13.2/OMSPatcher/

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/omspatcher.bat

   creating:
/opt/oracle/middleware_13.2/OMSPatcher/jlib/

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/jlib/omspatcher.jar

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/jlib/oracle.omspatcher.classpath.jar

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/jlib/oracle.omspatcher.classpath.unix.jar

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/jlib/oracle.omspatcher.classpath.windows.jar

   creating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/

   creating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/

   creating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery

  inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery.bat

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls.bat

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/omspatcher

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/omspatcher.bat

   creating:
/opt/oracle/middleware_13.2/OMSPatcher/wlskeys/

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/wlskeys/createkeys.cmd

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/wlskeys/createkeys.sh

   creating:
/opt/oracle/middleware_13.2/OMSPatcher/oms/

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/oms/generateMultiOMSPatchingScripts.pl

  inflating:
/opt/oracle/middleware_13.2/OMSPatcher/omspatcher

  inflating:
/opt/oracle/middleware_13.2/readme.txt

  inflating:
/opt/oracle/middleware_13.2/PatchSearch.xml

[oracle@cloud middleware_13.2]$ $OMS_HOME/OMSPatcher/omspatcher
version

OMSPatcher
Version: 13.8.0.0.1

OPlan Version:
12.2.0.1.6

OsysModel build:
Tue Nov 08 17:52:30 PST 2016

OMSPatcher
succeeded.

2. Apply Patch 24914115

[oracle@cloud middleware_13.2]$ cd /opt/oracle/patch

[oracle@cloud patch]$ 
wget —http-user=username —http-password=pass —no-check-certificate
—output-document=filename https://updates.oracle.com/Orion/Services/download/p24914115_132100_Generic.zip?aru=20792154&patch_file=p24914115_132100_Generic.zip

[oracle@cloud patch]$ unzip
p24914115_132100_Generic.zip

[oracle@cloud patch]$ cd 24914115/

[oracle@cloud 24914115]$ pwd

/opt/oracle/patch/24914115

[oracle@cloud 24914115]$ $ORACLE_HOME/OMSPatcher/omspatcher apply
-analyze

OMSPatcher
Automation Tool

Copyright
(c) 2016, Oracle Corporation.  All rights
reserved.

OMSPatcher
version : 13.8.0.0.1

OUI
version        : 13.8.0.0.0

Running
from       : /opt/oracle/middleware_13.2

Log
file location  :
/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/opatch2017-03-07_16-26-41PM_1.log

 OMSPatcher
log file:
/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-26-45PM_analyze.log

Please enter OMS weblogic
admin server URL(t3s://cloud2.ipx.com:7102):> t3s://cloud.ipx.com:7102

Please
enter OMS weblogic admin server username(weblogic):>

Please
enter OMS weblogic admin server password:>

Configuration Validation:
Success

Running apply prerequisite
checks for sub-patch(es) «24914115» and Oracle Home
«/opt/oracle/middleware_13.2″…

Sub-patch(es)
«24914115» are successfully analyzed for Oracle Home
«/opt/oracle/middleware_13.2»

Complete Summary

================

All log file names referenced
below can be accessed from the directory
«/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/2017-03-07_16-26-41PM_SystemPatch_24914115_1»

 Prerequisites
analysis summary:

——————————-

The following sub-patch(es)
are applicable:

Featureset                            Sub-patches                                     Log file

———-                              ————                                     ———

oracle.sysman.top.oms      24914115  
24914115_opatch2017-03-07_16-26-45PM_1.log 

Log file location: /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-26-45PM_analyze.log

OMSPatcher succeeded. 

[oracle@cloud 24914115]$
$ORACLE_HOME/OMSPatcher/omspatcher apply

OMSPatcher
Automation Tool

Copyright (c)
2016, Oracle Corporation.  All rights
reserved.

OMSPatcher version
: 13.8.0.0.1

OUI version        : 13.8.0.0.0

Running from       : /opt/oracle/middleware_13.2

Log file
location  :
/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/opatch2017-03-07_16-29-58PM_1.log

OMSPatcher log
file:
/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-30-02PM_deploy.log

Please enter OMS
weblogic admin server URL(t3s://cloud2.ipx.com:7102):> t3s://cloud.ipx.com:7102

Please enter OMS
weblogic admin server username(weblogic):>

Please enter OMS
weblogic admin server password:>

Configuration
Validation: Success

Running apply
prerequisite checks for sub-patch(es) «24914115» and Oracle Home
«/opt/oracle/middleware_13.2″…

Sub-patch(es)
«24914115» are successfully analyzed for Oracle Home
«/opt/oracle/middleware_13.2»

To continue,
OMSPatcher will do the following:

[Patch and deploy
artifacts]   :

Do you want to
proceed? [y|n] y

User Responded
with: Y

Applying
sub-patch(es) «24914115»

Please monitor log
file:
/opt/oracle/middleware_13.2/cfgtoollogs/opatch/opatch2017-03-07_16-30-02PM_1.log

Complete Summary

================

All log file names
referenced below can be accessed from the directory
«/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/2017-03-07_16-29-58PM_SystemPatch_24914115_1»

Patching summary:

——————

Binaries of the
following sub-patch(es) have been applied successfully:

Featureset                                                   Sub-patches                                     Log file

———-                                                                ————                                     ———

  oracle.sysman.top.oms_13.2.0.0.0      24914115  
24914115_opatch2017-03-07_16-30-02PM_1.log

Log file location:
/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-30-02PM_deploy.log

OMSPatcher
succeeded.

3. Restart  OMS

[oracle@cloud 24914115]$
/opt/oracle/middleware_13.2/bin/emctl stop oms –all

[oracle@cloud 24914115]$
/opt/oracle/middleware_13.2/bin/emctl start oms

To get more
information please check Oracle Support Doc ID 2199723.1

Источник

  • Ошибка ora 06550 pls 00201
  • Ошибка ora 06413 соединение не открыто
  • Ошибка ora 04088 error during execution of trigger
  • Ошибка ora 03113 end of file on communication channel
  • Ошибка ora 02291 integrity constraint