subject:"Stored Procedures Parameters"

Stored Procedures Parameters

2004-10-21 Thread Denesa K Shaw

Hi, I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File. After the stored procedure executes, it returns an out parameter called out_v_RECV_FILE_NM. I have a perl script which uses the DBI:: Module. My Question is: Is the correct way retrieve the value of my out

RE: Stored Procedures Parameters

2004-10-21 Thread Reidy, Ron

There are examples in the DBD::Oracle docs. - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Denesa K Shaw [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 2:28 PM To: [EMAIL PROTECTED] Subject: Stored Procedures Parameters Hi, I'm

Re: Stored Procedures Parameters

2004-10-21 Thread Scott T. Hildreth

perldoc DBD::Oracle will show you how to do this. On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote: Hi, I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File. After the stored procedure executes, it returns an out parameter called out_v_RECV_FILE_NM. I have a perl

Re: Stored Procedures Parameters

2004-10-21 Thread Scott T. Hildreth

Sorry, I am assuming you are using Oracle, are you? Look for bind_paraminout(). On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote: perldoc DBD::Oracle will show you how to do this. On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote: Hi, I'm calling a stored procedure called

Re: Stored Procedures Parameters

2004-10-21 Thread Scott T. Hildreth

...bind_param_inout(), typo. On Thu, 2004-10-21 at 08:36, Scott T. Hildreth wrote: Sorry, I am assuming you are using Oracle, are you? Look for bind_paraminout(). On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote: perldoc DBD::Oracle will show you how to do this. On Wed,