Getting values from Oracle stored procedure

[Galbraith, Mark]

I have been asked to call a stored procedure, and then use the value stored in a 
variable inside the package.  I've looked at the documentation, including the 
appropriate chapters in Programming The Perl DBI (O'Reilly).

I found that by changing the procedure to a function, I can call the function and bind 
the variable using bind_param_inout().  My question is, is this the only way to do 
this?  Is there a better way?

Environment:

        Perl version 5.6.1      
        Oracle 8.1.6 drivers
        Perl DBI version 1.21
        Perl DBD::Oracle version 1.12

Thanks in advance for any help you can give me.

-- 
Mark Galbraith
Managed Services Team Leader
Data Return LLC