View unanswered posts | View active topics It is currently Tue Nov 28, 2023 5:07 pm

Reply to topic  [ 2 posts ] 
 Oracle refCursor in PHP thru ODBC 
Author Message
Junior Member

Joined: Fri Sep 23, 2005 8:44 am
Posts: 8
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)
OPEN po_refcur FOR
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
OPEN po_refcur FOR
SELECT detailvalue
FROM orgdetails
WHERE orgid = p_org_id AND detailname = p_detail_name;

Iam new to PHP, and Help me out.


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

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:  
© Copyright 2003-2008 The ultimate PHP Editor and PHP IDE site.