On Fri, 17 May 2002 16:04:28 -0800 Brian Avis <[EMAIL PROTECTED]> wrote:

> I have some SQL lying around like this.
> . . .
> The way that the user has been using this SQL is to put it in a text 
> file, feed that text file to sqlplus  and have that output to a text 
> file that they can play with.  I would like to be able to do all this in 
> the program using DBI.  Is it possible?  What do I need to do to get it 
> to work?

Hint: SQL*Plus != SQL.

> I tried just feeding all that stuff into and sth->prepare and then and 
> execute but it said that it wasn't a valid SQL statement.    
> 
> I don't know if it matters but this is an oracle database running on 
> solaris.

The fine manual would be a good starting point.

perldoc DBI
perldoc DBD::Oracle

-- 
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.


Reply via email to