Sql-dev 4.1.2 unit testing - unsupported typea
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:
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