Re: Using Oraperl for the first time... (was: Using DBI for the first time...)

In list context, ora_fetch() returns an array, one element per field. It does not return all rows. You'll have to call it in a while loop for that. See Oraperl for more details, 'cuz the error checking isn't that great.

(Of course, Oraperl is, more or less, backwards compatibility for perl 4 scripts. It's probably better to bite the bullet and move to DBI for new programs.)

Comment on Re: Using Oraperl for the first time... (was: Using DBI for the first time...)

Replies are listed 'Best First'.
Re: Re: Using Oraperl for the first time... (was: Using DBI for the first time...) by snafu (Chaplain) on Aug 21, 2001 at 09:48 UTC
Wow! So, if there are 300 rows each with only one element per and that particular column isn't indexed then potentially I could be doing 300 full table scans to get the information I want using Oraperl? That will take absolutely forever! Is using DBI going to alleviate that possibility? How did people get along with this back in the day?!?! :) ---------- - Jim	[reply]