On 11/02/11 17:33, tran...@commerceinsurance.com wrote:
> I'm sorry in advance if this is not the correct forum/mechanism to ask
> this question - I have been googling this for a while, as well as
> re-reading all of the CPAN man page for DBD-Oracle.
>
> I need to pass a physical file( or the contents of that file), that
> contains code to create an Oracle stored procedure into DBD-Oracle. So
> like SQL PLus, where I'd say > @package.spb, I have been trying to do the
> same in every way imaginable with $DBH->prepare / do. As of right now,
> this is not working:
>
> # load file contents
> open (FILEDATA, "$sql");
> while ($record = <FILEDATA>) {
> print $record;
> }
> close(FILEDATA);
You have opened the file named "$sql", read it line-by line,
printing each line as yo go.
$record is now undefined. Passing it to prepare won't work.
> # prepare the stored procedure
> if ($sth = $DBH->prepare( $record )){
> print $LOG "prepared: $HoH{$filename}{'full_filename'} \n";
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
