Re: What is the limitation to use DBD::Oracle module?

From: Tim Bunce <Tim.Bunce_at_ig.co.uk>
Date: 1997/03/31
Message-ID: <E7wpxp.Dtv@ig.co.uk>#1/1

In article <5gdp8g$pai$3_at_news.hkol.com>, Pao Wan <paowan_at_drdun.com> wrote:
> Is the Oracle module for perl only support a limited subset of Oracle SQL?
> Will it be wise to switch PL/SQL with Oracle Webserver?

DBD::Oracle uses Oracle's own interface (OCI) and has full use of SQL.

Here's a chunk of code demonstrating both PL/SQL and input/output variable:

  $csr = $dbh->prepare(q{

      declare bar varchar2(200);
      begin
          bar := :1;
          bar := '**'||bar||'**';
          :1 := bar;
      end;

  }) || die $DBI::errstr;
  $param = "foo";
  $csr->bind_param_inout(1, \$param, 100) || die $DBI::errstr;

  $csr->execute || die $DBI::errstr;
  print "param='$param'\n";

After the execute call $param will automatically hold the new value.

Tim. Received on Mon Mar 31 1997 - 00:00:00 CST