0 Replies Latest reply on Nov 18, 2015 2:08 PM by KarstenH-dk

    Sql-dev 4.1.2 unit testing - unsupported typea

    KarstenH-dk

      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