SqlServer Example:
$query = "declare @CMID numeric
exec @CMID = ".$CDatabaseOwner."InsertNewCM $GOrgID, '".$stRequester."', '".$stReasonCode."'
select @CMID as CMID";


OCI Example in Oracle
$query = OCIParse($link ,"BEGIN PKG_CMT_PROCS.InsertNewCM(:GOrgID,:stRequester,:stReasonCode,:p_CMID);END;");
OCIbindByName($query, "GOrgID", $GOrgID,1);      
OCIbindByName($query, "stRequester", $stRequester,100);      
OCIbindByName($query, "stReasonCode", $stReasonCode,100);
OCIbindByName($query, "p_cmid", $CMID, 10);
     
"select @CMID CMID";

$result = ociexecute($query) ;

Please tell me where iam doing wrong compared to Oracle and SqlServer.

I want to make this work in Oracle but forsome reason iam not able to get the CMID value, as I dont know how to declare in ORacle and also How to make Concat Work.


Thanks
P.Reddy

---