oracle stored procedure?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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;");



if so what do i do next to loop through the results set retrieving
values from the row?

regards and thanks

Re: oracle stored procedure?

Quoted text here. Click to load it

 Have a look at

Andy Hassall :: :: :: disk and FTP usage analysis tool

Site Timeline