Re: DBI (oracle question)

From: Jim Lyons <j.lyons_at_cc.utexas.edu>
Date: Thu, 03 Sep 1998 11:25:54 -0500
Message-ID: <35EEC311.5F1F@cc.utexas.edu>

Ron Reidy wrote:
>
> Hi,
>
> I am writing a Perl program to go against some **extremely** large tables in
> Oracle. I need to put some hints into the query I will be using, but when I
> do, I get an error message from the prepare method.
>
> Does anyone know how to do this properly (an example would be great!)?

I can use hints in Perl. It's not clear whether your problem is with Perl or SQL.

Could you provide the Perl code, or at least sample code to demonstrate the call you use?

Are you sure the SQL is correct? Have you taken the code that runs in Perl and run it in SQLPLUS, for example, to make sure the problem is not syntactical?

--

Jim Lyons                     |  Operating Systems Specialist
ACITS                         |  512-475-9331

University of Texas at Austin | j.lyons_at_cc.utexas.edu http://uts.cc.utexas.edu/~jlyons Received on Thu Sep 03 1998 - 11:25:54 CDT