Executing stored procedure using Perl

[James Laver]

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