Re: Perl DBI/SQL question - For those who use it...

in case this is a windog machine - install kind of unix shell. and the unix style commands work perfectly - just tried it. either use unix tools for windog or cygwin from rh. or dump the w...
have fun.

>>> Lisa.Koivu_at_efairfield.com 01/03/03 18:40 PM >>>
Hi everyone,

This may be a stupid question. If so please humor me with a stupid answer. However:

I FINALLY have the fun fun fun chance to change one of my data loads to use the DBI instead of the procedures I hacked together. In true ksh style I had written my loads to fire a sql script (calling a stored proc) that was stored separately. It seems to me the DBI wants the text of the sql script embedded piece by piece in the code. I have looked around for examples because even though the DBI seems straightforward, it doesn't take much to confuse me. I don't see examples of firing a sql script from the DBI (like this sqlplus /@dbname < @script.sql > logfile.log ... Gosh do I miss unix, everything was SO EASY)

So my questions to you, my learned friends, are:

1. is it not perl-style to store the sql in a separate file? I understand I may be missing the opportunity for more specific error handling here but honestly at this point it does not matter. The thing fails, I restart the whole script.
2. Does anyone have an example of firing the DBI and calling a sql script like I could so easily do in ksh?

Any and all comments are welcome. Thank you

I wish everyone a rested and relaxing weekend.

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Markus Reger
  INET: reger_at_mdw.ac.at

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).