fetch out of sequence

[Rod]

Hi,

I would like to know if there is a similar function with OCI8 (oracle) to
this one: mysql_data_seek ?

I would like to do twice:
while (ocifetch($stmt)) {
....
}

How can I set the cursor to the first element?

Thanks your for your help

Rodolphe

[Andy Hassall]

On Thu, 20 Nov 2003 09:41:27 +0100, "Rod" <toto@toto.com> wrote:

>I would like to know if there is a similar function with OCI8 (oracle) to
>this one: mysql_data_seek ?
>
>I would like to do twice:
>while (ocifetch($stmt)) {
>...
>}
>
>How can I set the cursor to the first element?

Scrollable cursors were only introduced in Oracle 9i; as far as I know, the
PHP interface hasn't been updated to support the new calls to navigate within a
result set.

So you can only fetch forwards. If you want to go back, you will have to have
stored the results in an array yourself, or re-execute the query.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

[Rod]

thanks you for your answer.

Rodolphe

"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:0j5qrv4nmrvrlkh35iru2f7ae5ifgdmckm@4ax.com...

> On Thu, 20 Nov 2003 09:41:27 +0100, "Rod" <toto@toto.com> wrote:
>

> >I would like to know if there is a similar function with OCI8 (oracle) to
> >this one: mysql_data_seek ?
> >
> >I would like to do twice:
> >while (ocifetch($stmt)) {
> >...
> >}
> >
> >How can I set the cursor to the first element?

>
> Scrollable cursors were only introduced in Oracle 9i; as far as I know,

the

> PHP interface hasn't been updated to support the new calls to navigate

within a

> result set.
>
> So you can only fetch forwards. If you want to go back, you will have to

have

> stored the results in an array yourself, or re-execute the query.
>
> --
> Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
> Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

[ricco95]

Has anybody experienced problems with an oracle error "fetch out of sequence"
in the follwing scenario:?
"select * from external linked table"
Where external table comes from a machine linked to the main database server.
This works in a cfquery but if I put it in stored procedure and then call it
from Coldfusion I get the dreaded out of sequence error.

Thanks for your help

[paross1]

What does your PL/SQL look like? Are you using a FOR UPDATE clause in a cursor by any chance and doing any kind of COMMIT within the cursor loop, etc.?

Phil

[Stifenflaming]

This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error.

http://www.alphaconfig.com/