This discussion is archived
1 Reply Latest reply: May 4, 2013 10:26 AM by 997232 RSS

The simplest question about query in multimedia

997232 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 ;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points