View unanswered posts | View active topics It is currently Fri Oct 20, 2017 11:13 am



Reply to topic  [ 1 post ] 
 Oracle refCursor in PHP thru ODBC 
Author Message
Junior Member

Joined: Fri Sep 23, 2005 8:44 am
Posts: 8
Post 
My question is Iam using an Oracle Database, and Trying to access a Procedure in a Package which returns the ref Cursor. My code is not working, Please any help would be great.

$curs = ("begin PKG_CMT_PROCS.getallactiveorgs(SQL_CUR_USE_ODBC); end;");
populateV4Dropdown($link, $Qury, "OrgName", "OrgID")

The $link is declared in Other .INC File.
and the Procedure for the above code is
PROCEDURE getallactiveorgs (po_refcur OUT refcur)
IS
BEGIN
OPEN po_refcur FOR
SELECT *
FROM org
WHERE orgid >= 0 AND active = 'Y'
ORDER BY orgname;
END getallactiveorgs;

and there is one more where Iam passing 2 parameters :
$reqQuery = "PKG_CMT_PROCS.GetOrgDetail ('$GOrgID' , 'AllowBlankPassword')";

Heres the Procedure :
PROCEDURE getorgdetail (
p_org_id NUMBER,
p_detail_name VARCHAR2,
po_refcur OUT refcur
)
IS
BEGIN
OPEN po_refcur FOR
SELECT detailvalue
FROM orgdetails
WHERE orgid = p_org_id AND detailname = p_detail_name;
END;

Iam new to PHP, and Help me out.

Thanks
Reddy


Wed Sep 28, 2005 6:50 am
Report this post
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.