Executing stored procedure using Perl

[James Laver]

On Wed, Mar 19, 2008 at 3:18 PM, James Laver <james.laver at gmail.com> wrote:
>
> On Wed, Mar 19, 2008 at 2:40 PM, Hemant Verma
>  <Hemant.Verma at ons.gsi.gov.uk> wrote:
>  > Can any body please let me know how I can execute a procedure from PL/SQL
>  >  using per?
>  >
>  >
>  >  For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk
>  >
>  >  *********************************************************************************
>  >
>  >
>  >  Please Note:  Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
>  >  *********************************************************************************
>  >
>  >
>  >  Legal Disclaimer  :  Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
>  >  *********************************************************************************
>  >
>  >
>  >  The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free.
>  >  Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
>  >
>
>  By querying in the same way you'd execute one via plain old SQL.
>
>  Often it's one that can be used in a select, so something like this:
>
>  my $stmt = $dbh->prepare("SELECT MY_PROC(?,?);");
>  $stmt->execute;
>  # Do stuff with any results...
>
>  --James
>

Except since I used placeholders you'd want to pass something into execute
$stmt->execute($a,$b);

Need more caffeine...

--James