Ошибка pls 306

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

Источник

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

Источник

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?

Источник

Есть ещё один вопрос.
Как правильно передать переменную Дата.
Пробовал следующие варианты

на эти две
CONCATENATE »» ‘01.05.2010’ »» ‘,’ »» ‘DD.MM.YYYY’ »» into DDATE_FROM.
DDATE_FROM = ‘01.05.2010’,’DD.MM.YYYY’.

Code:

Database error text……..: «ORA-01858: a non-numeric character was found 
  where a numeric was expected#ORA-06512: at line 1″                         
Database error code……..: 1858                                           
Triggering SQL statement…: «EXECUTE PROCEDURE UDO_PROV»                   
Internal call code………: «[DBDS/NEW DSQL]» 

На эту попытку
DDATE_FROM = ‘01052010’.
выдает

Code:

Database error text……..: «ORA-01861: literal does not match format   
string#ORA-06512: at line 1″                                             
Database error code……..: 1861                                         
Triggering SQL statement…: «EXECUTE PROCEDURE UDO_PROV»                 
Internal call code………: «[DBDS/NEW DSQL]»       

Функцию в Парусе видоизменили

Code:

CREATE OR REPLACE PROCEDURE PARUS.UDO_PROV
(
S        IN DATE,
S2       OUT VARCHAR2
)
AS

BEGIN
S2:=S;
END;

Если спросите зачем я это делаю, то отвечу:
Надо запустить процедуру, в Парусе, с 37 переменными, т.к. там 3 вида переменных, VARCHAR2, DATE и number, то глючит у меня Дата.

Получилось вот так

Code:

    EXEC SQL.
        EXECUTE PROCEDURE UDO_PROV  ( IN :’01-APR-10′, OUT :YY )
    ENDEXEC.

ну и на вывод получил тоже самое, что и требовалось
01-APR-10
вот теперь думаю что делать , так и использовать или мож кто что посоветует.

Источник
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

--Создание процедуры добавления в таблицу Product  
CREATE OR REPLACE PROCEDURE INSERTproduct (
p_productid             IN          INT,
p_categoryid            IN          INT,
p_manufacturerid        IN          INT,
p_productstatusid       IN          INT,
p_name                  IN          varchar2, 
p_discription           IN          varchar2,
p_date_from             IN          DATE,
p_date_to               IN          DATE,
p_create_data           IN          DATE,
p_update_data           IN          DATE
)
IS
 
BEGIN
INSERT INTO product (product_id, category_id, manufacturer_id, product_status_id, name, discription, date_from, date_to, create_data, update_data)
VALUES (product_seq.NEXTVAL, 3, 6, 1, 'efefeegeg', 'syhyhyhys', '12-04-2020', NULL, sysdate, sysdate);
END INSERTproduct;
 
EXECUTE INSERTproduct
Источник

Понравилась статья? Поделить с друзьями:
  • Ошибка pls 00201
  • Ошибка please wait point blank
  • Ошибка please select boot device
  • Ошибка please run updater exe as admin
  • Ошибка please run a virus check