executing package not working
Posted by pagalreddy (pagalreddy), 12 October 2005$GOrgID = $_SESSION['OrgID'];
$curs = ocinewcursor($link);
$query = OCIParse($link,"BEGIN PKG_CMT_PROCS.GetOrgDetails(:GOrgID,:po_refcur);END;");
OCIbindByName($query, ":GOrgID", &$GOrgID,1);
OCIbindByName($query, ":po_refcur", &$curs, -1, OCI_B_CURSOR);
$result = ociexecute($query);//for this organisation
if ($query) //If no data
// ============================for every piece of data ...
$PropertyName = ociresult ($curs,"DetailName");
$PropertyValue = ociresult($curs,"DetailValue");
$name = "G".$PropertyName;
$_SESSION[$name] = $PropertyValue;
Please do help me out if fixing the Cdatabaseowner in my previous problem and also let me know where and what IAm doing wrong ?
Posted by admin (Graham Ellis), 13 October 2005on 10/12/05 at 17:19:56, pagalreddy wrote:
If you have any follow up problems, it would be a great help if you can post them in the same thread. That way, we'll understand better what you're referring to.
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho