Pagalreddy
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) 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
|