Oracle procedure + php

Do you have questions regarding other database enginges (not MySQL) -- ask here!

Moderators: macek, egami, gesf

raf
New php-forum User
New php-forum User
Posts: 1
Joined: Fri May 10, 2013 5:14 am

Oracle procedure + php

Postby raf » Fri May 10, 2013 5:18 am

Hi, i have procedure:

create or replace
PROCEDURE "PROC2"
(
pod IN fotkiord.fotkaid1%type,
pod1 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;
myAvgColor := NEW SI_AverageColor(myimage);
SELECT fotka1 INTO myotherimage FROM fotkiord
WHERE fotkaid1 = pod1;
score := myAvgColor.SI_Score(myotherimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END ;

i want to call this procedure using php. Fisrt window user will write id1, second window id2 and submit.
Please give me directions.

Return to “Other Database Engines”

Who is online

Users browsing this forum: No registered users and 1 guest