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
|