Entry

How do I get the result from a procedure with an array as OUT parameter?

Apr 20th, 2004 18:30
Eyzen Medina, Tomas Albinsson,

Hi:
You have to use a cursor as out parameter.
First you have to declare a cursor type with the same table definition 
and past to the procedure as Out Parameter.
Sample
TYPE CUR_PHP_LINES IS REF CURSOR RETURN VW_ORDER_LINE%ROWTYPE;
// The type CUR_PHP_LINES AS VW_ORDER_LINE%ROWTYPE  
Use a view when you don't want return a complete table.
In the procedure declare.
PROCEDURE NavigateOrders
( 
Pv_Rec OUT CUR_PHP_LINES 
) 
IS
OPEN Pv_Rec FOR SELECT * FROM MyTable
END;
So in your PHP Code
$db = OCILogon(DBUSER,DBPASSWORD);
$curs = OCINewCursor($db);
$STR_TO_PARCE = "begin NavigateOrders(:Pv_Rec); end;";
$stmt = OCIParse($db,$STR_TO_PARCE);
OCIBindByName($stmt,":Pv_Rec",$curs,-1,OCI_B_CURSOR);
OCIExecute($stmt);
OCIExecute($curs);
while(OCIFetchInto($curs,$data)){
	var_dump($data);
}
@OCIFreeCursor($curs);
@OCIFreeStatement($stmt);
@OCILogoff($db);
Tha's All :)
Eyzen