Board index   FAQ   Search  
Register  Login
Board index php forum :: Database Other Database Engines

Oracle procedure + php

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

Moderators: macek, egami, gesf

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.
raf
New php-forum User
New php-forum User
 
Posts: 1
Joined: Fri May 10, 2013 5:14 am

Return to Other Database Engines

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron