Re: oraperl problem: &ora_titles, &ora_types, &ora_lengths

From: Tim Bunce <Tim.Bunce_at_ig.co.uk>
Date: Fri, 10 Feb 1995 11:39:42 +0000
Message-ID: <D3s8E6.900_at_ig.co.uk>


In article <MIKEW.95Feb8094836_at_gopher.dosli.govt.nz>, Mike Williams <mikew_at_gopher.dosli.govt.nz> wrote:
>>>> On 6 Feb 1995 22:33:17 GMT,
>>>> "Arthur" == ayasinsk_at_nofc.forestry.ca (Arthur Yasinski) wrote:
>
>Arthur> I am encountering a weird anomaly with oraperl 2.004 and my Oracle
>Arthur> v7.0.16 database. Normally, everything works fine, but some times,
>Arthur> the three functions &ora_titles, &ora_types, and &ora_lengths
>Arthur> neglect to return the first item.
>

As a quick workaround try adding a dummy first field to the query:

        select 'dummy', * ...

> I had a similar problem with Oracle 7 under OSF/1 on a DEC Alpha. You
> could try the appended patch.

Thanks for that. I've added it to the archive.

Regards,
Tim Bunce. Received on Fri Feb 10 1995 - 12:39:42 CET

Original text of this message