oracle stored procedure?

[buzz]

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

[Andy Hassall]

On 23 Oct 2006 18:21:30 -0700, "buzz" <bz****@yahoo.com.auwrote:

>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?

Have a look at http://uk2.php.net/manual/en/functio...new-cursor.php

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool