Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql-dev 4.1.2 unit testing - unsupported typea

KarstenH-dkNov 18 2015 — edited Nov 18 2015

Hi

Sql-dev 4.1.2 unit testing does not support certain arguments as parameters to procedures .

Sql-dev 4.1.2 unit testing show this when trying to create a test concerning this procedure

the procedure to test:

create or replace procedure test_af_advis_skriv(advis_tab_in in daf_mms.advis_ct) authid definer as

.......

the reply from unit test in Sql dev:

unsup.jpg

daf_mms.advis_ct is constructed this way

create or replace type Advis_detalje_ot

authid definer

as object

(

Vigtighed Number

,Blokerende Number

,Score Number

,RegelBeskrivelse varchar2 (4000 char)

,constructor function Advis_detalje_ot (

                    SELF in out nocopy Advis\_detalje\_ot

,Vigtighed Number default null

,Blokerende Number default null

,Score Number default null

                   ,RegelBeskrivelse  varchar2 default null)

return self as result

);

/

create or replace type body Advis_detalje_ot

is

constructor function Advis_detalje_ot (

                    SELF in out nocopy Advis\_detalje\_ot

,Vigtighed Number default null

,Blokerende Number default null

,Score Number default null

                   ,RegelBeskrivelse  varchar2 default null)

return self as result

is

begin

Self.Vigtighed := Vigtighed;

Self.Blokerende := Blokerende;

Self.Score := Score;

Self.RegelBeskrivelse := RegelBeskrivelse;

return;

end;

end;

/

create or replace type Advis_ot

authid definer

as object

(

AdvisNr number (15,0)

,AdvisType number (15,0)

,Kort_txt varchar2 (30 char)

,Komponent varchar2 (10 char)

,Tekst varchar2 (500 char)

,Detaljer Advis_detalje_ot

,Tidspunkt Date

,Aktuel Number

,constructor function Advis_ot (

SELF in out nocopy Advis_ot

,AdvisNr Number Default null

,AdvisType number Default null

,Kort_txt varchar2 Default null

,Komponent varchar2 Default null

,Tekst varchar2 Default null

,Detaljer Advis_detalje_ot Default null

,Tidspunkt Date Default null

,Aktuel Number Default null)

return self as result

);

/

create or replace type Advis_ct is table of Advis_ot;

/

regards Karsten

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 16 2015
Added on Nov 18 2015
0 comments
408 views