Posted by Andy Hassall on 10/25/06 17:42

On 23 Oct 2006 18:21:30 -0700, "buzz" <bzburr@yahoo.com.au> wrote:

>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/function.oci-new-cursor.php

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

[Back to original message]