|
|
Posted by buzz on 10/24/06 01:21
HI all
am pretty new to php
the oracle blokes here at work have prepared a stored procedure they
say returns a recordset
==
c_cur := gi_house_api.get_house_asset_data('10A', '2', 3.5);
==
i am struggling to figure out how to get at the result set from php
am i correct with the following?
==
...
$mySet = "";
$stmt = OCIParse($conn, "begin: mySet := from
gi_rio_api.get_road_section_id(11); end;");
OCIBindByName($stmt,":mySet",&$mySet);
OCIExecute($stmt);
OCIResult($stmt,$mySet);
==
if so what do i do next to loop through the results set retrieving
values from the row?
regards and thanks
Buzz
Navigation:
[Reply to this message]
|