On May 11, 2010, at 12:25 PM, tech422 wrote:
> Hi,
>
> I am trying to query an Oracle database and output the results to a
> file using PERL but its not working. I have tried 2 approaches. 1 uses
> bind the other does not. Could you please advise?
This is my usual route:
while (($col1,$col2,$cms_gateway_name,$cms_gateway_ip_address,
$cms_subnet_mask,$cms_subnet_notation,$cms_subnet_name,$cms_vlan_no) =
$sth->fetchrow()){...}
I know that works, I do it all the time.
Silly question, have you tested the query in SQLPlus or some other tool to
confirm that you're getting any rows?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
