Re: Question about passing a stored procedure file to DBD-Oracle

On 11/02/11 17:33, [email protected] 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
[email protected]    Tel: +44 1223 334506, Fax: +44 1223 334679