1 Reply Latest reply: May 4, 2013 12:26 PM by 997232 RSS

    The simplest question about query in multimedia

    997232
      Hi i write in command line
      DECLARE
      score DOUBLE PRECISION;
      myimage SI_StillImage;
      myotherimage SI_StillImage;
      myAvgColor SI_AverageColor;
      BEGIN
      SELECT fotka1 INTO myimage FROM fotkiord WHERE fotkaid1=71;
      myAvgColor := NEW SI_AverageColor(myimage);
      SELECT fotka1 INTO myotherimage FROM fotkiord
      WHERE fotkaid1=72;
      score := myAvgColor.SI_Score(myotherimage);
      DBMS_OUTPUT.PUT_LINE('Score is ' || score);
      END;

      and I get from script output

      anonymous block completed


      Where i can find the real output of my query ??
        • 1. Re: The simplest question about query in multimedia
          997232
          ok i answerd my own question

          create or replace
          PROCEDURE "PROC2"
          (
          pod_id IN fotkiord.fotkaid1%type,
          pod1_id IN fotkiord.fotkaid1%type)
          IS
          score DOUBLE PRECISION;
          myimage SI_StillImage;
          myotherimage SI_StillImage;
          myAvgColor SI_AverageColor;
          BEGIN
          SELECT fotka1 INTO myimage FROM fotkiord WHERE fotkaid1= pod_id;
          myAvgColor := NEW SI_AverageColor(myimage);
          SELECT fotka1 INTO myotherimage FROM fotkiord
          WHERE fotkaid1= pod1_id;
          score := myAvgColor.SI_Score(myotherimage);
          DBMS_OUTPUT.PUT_LINE('Score is ' || score);
          END ;