Thread: Ref cursor help nedded
11-22-10, 21:18 #1Registered User
- Join Date
- Nov 2010
Unanswered: Ref cursor help nedded
I want to have ref cursor to return value so that i can use it on my front end php. the procedure works fine but without returning ref cursor value as paramter. Please help me with this issue i'm stuck with this from 3 days now.
CURSOR getphotos IS
SELECT product_id, ORDSYS.IMGScore(123), product_photo
FROM pm.online_media WHERE
'color="0.2" texture="0.1" shape="0.5" location="0.2"', 20, 123) = 1;
SELECT product_photo_signature INTO query_signature
WHERE product_id = 1910;
FETCH getphotos INTO id, img_score, t_img;
EXIT WHEN getphotos%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('Image with ID '|| id ||
' matches query image with score ' ||
Many thanks in advance.
11-22-10, 23:39 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
FUNCTION returns a value
First make it work, then make it fancy.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.