insert null into number data type in plsql package

Question

I have a procedure something like

       create or replace package pack_body
         as
        procedure export(P_LOCATION_ID number
                         ,retcode OUT   NOCOPY   NUMBER)
         as
         ----body
        end;

I am calling this package in another package

pack_body.export(p_location_id => null);

At this line it is going into error:

Error(28412,5): PLS-00306: wrong number or types of arguments in call to 'EXPORT'

I cannot pass null into number data type variable ?

Try passing in the second argument, retcode.

Gordon Linoff
– Gordon Linoff

2016-01-14 13:22:42 +00:00
Commented Jan 14, 2016 at 13:22 — Gordon Linoff
– Gordon Linoff, Commented Jan 14, 2016 at 13:22
Its an out parameter.... what should i pass.. in this

divya.trehan573
– divya.trehan573

2016-01-14 13:25:04 +00:00
Commented Jan 14, 2016 at 13:25 — divya.trehan573
– divya.trehan573, Commented Jan 14, 2016 at 13:25

MT0 · Accepted Answer · 2016-01-14 13:27:11Z

4

You need to pass both arguments to the procedure:

DECLARE
  rc NUMBER;
BEGIN
  pack_body.export(
    p_location_id => null,
    retcode       => rc
  );
END;
/

answered Jan 14, 2016 at 13:27

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Indiecoder · Accepted Answer · 2016-01-14 14:00:41Z

0

Since thisretcode is an OUT parameter,it means that a value is being returned from that particular procedure pack_body.export and is being assigned in the variable retcode

so while calling this procedurepack_body.export you need to declare some local variable in your procedure of same data type in which the value of retcode can be assigned. Hence you getting this error.

You cannot use null as assignment target hence you need to declare a varible locally of same datatype

answered Jan 14, 2016 at 14:00

Indiecoder

1863 silver badges19 bronze badges

Collectives™ on Stack Overflow

insert null into number data type in plsql package

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related