Re: Stored Procedure (arguments)

2001-03-13 Thread Peter J . Holzer
On 2001-03-12 21:38:45 -0700, Peter Loo wrote: 1) $DICEpackage is a store procedure we use internally. So your package is actually called $DICEpackage? There is no perl variable of this name which contains the name of the package? Then this is the problem. Perl replaced $DICEpackage with the

Re: Stored Procedure (arguments)

2001-03-13 Thread Michael A. Chase
ichael A. Chase" [EMAIL PROTECTED]; "Loo, Peter # PHX" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 12, 2001 8:38 PM Subject: RE: Stored Procedure (arguments) 1) $DICEpackage is a store procedure we use internally. That's your error this time. Perl is trying to interpo

Re: Stored Procedure (arguments)

2001-03-13 Thread Michael A. Chase
ichael A. Chase" [EMAIL PROTECTED]; "Loo, Peter # PHX" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 12, 2001 8:38 PM Subject: RE: Stored Procedure (arguments) 1) $DICEpackage is a store procedure we use internally. That's your error this time. Perl is trying to interpo

Re: Stored Procedure (arguments)

2001-03-13 Thread Michael A. Chase
]; "Loo, Peter # PHX" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 4:23 AM Subject: Re: Stored Procedure (arguments) - Original Message - From: "Peter Loo" [EMAIL PROTECTED] To: "Michael A. Chase" [EMAIL PROTECTED]; "Loo, Peter # P

Re: Stored Procedure (arguments)

2001-03-13 Thread Thomas A . Lowery
Checking the DBD::Oracle version: perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"' 1.06 Tom -- Thomas A. Lowery[EMAIL PROTECTED] http://tlowery.hypermart.net _ Do You Yahoo!? Get your free @yahoo.com address at

RE: Stored Procedure (arguments)

2001-03-13 Thread Loo, Peter # PHX
Michael, Thanks for all your advise. I will give them a try now. Peter -Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 5:23 AM To: Peter Loo; Loo, Peter # PHX; [EMAIL PROTECTED] Subject: Re: Stored Procedure (arguments) Comments

RE: Stored Procedure (arguments)

2001-03-13 Thread Loo, Peter # PHX
('sl:ctdm'); Thanks. Peter -Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:02 AM To: Peter Loo; Loo, Peter # PHX; [EMAIL PROTECTED] Subject: Re: Stored Procedure (arguments) I forgot to mention. You are not checking for errors after the

RE: Stored Procedure (arguments)

2001-03-13 Thread Loo, Peter # PHX
if ($@) { DB10 p $sth DBI::st=HASH(0x3aae84) DB11 q runAgg_TAlgnRxTerrSpcltDrugPlan.pl[2]: /export/home/ip00622: cannot execute -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:18 AM To: 'Michael A. Chase'; Peter Loo; Loo, Peter #

Re: Stored Procedure (arguments)

2001-03-13 Thread Michael A. Chase
"'Michael A. Chase'" [EMAIL PROTECTED]; "Loo, Peter # PHX" [EMAIL PROTECTED]; "Peter Loo" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 12:21 PM Subject: RE: Stored Procedure (arguments) You seem to have the right number of arguments. What types are

RE: Stored Procedure (arguments)

2001-03-12 Thread Loo, Peter # PHX
]' Subject: Re: Stored Procedure (arguments) Peter, My guess is that you need comma's between the arguments of a procedure/function : $sth = $dbh-prepare("BEGIN $DICEpackage.DROP_INDEXES(:1:2:3); END;"); should be : $sth = $dbh-prepare("BEGIN $DICEpackage.DROP_INDEXES(:

RE: Stored Procedure (arguments)

2001-03-12 Thread Sterin, Ilya
'; Loo, Peter # PHX Cc: '[EMAIL PROTECTED]' Subject: RE: Stored Procedure (arguments) Mark, I tried it with commas also and it gave me the same error message. I tried using the bind also and not successful. Peter -Original Message- From: Mark Vandenbroeck [mailto:[EMAIL PROTECTED

RE: Stored Procedure (arguments)

2001-03-12 Thread Loo, Peter # PHX
To: 'Mark Vandenbroeck'; Loo, Peter # PHX Cc: '[EMAIL PROTECTED]' Subject: RE: Stored Procedure (arguments) Mark, I tried it with commas also and it gave me the same error message. I tried using the bind also and not successful. Peter -Original Message- From: Mark Vandenbroeck [mailto

RE: Stored Procedure (arguments)

2001-03-12 Thread Sterin, Ilya
Vandenbroeck' Cc: [EMAIL PROTECTED] Subject: RE: Stored Procedure (arguments) How do you check for a correct version? I am seeing all sort of information with different values. -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 5:14 PM To: Loo, Peter

RE: Stored Procedure (arguments)

2001-03-12 Thread Loo, Peter # PHX
ndenbroeck' Cc: [EMAIL PROTECTED] Subject: RE: Stored Procedure (arguments) Forgot how to do the easy way, but just print out the $DBD::Oracle::VERSION Did it work with '?' instead of ':1' Ilya Sterin -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]] Sent: Monday, Marc

RE: Stored Procedure (arguments)

2001-03-12 Thread Loo, Peter # PHX
: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 5:38 PM To: Loo, Peter # PHX; 'Mark Vandenbroeck' Cc: [EMAIL PROTECTED] Subject: RE: Stored Procedure (arguments) Forgot how to do the easy way, but just print out the $DBD::Oracle::VERSION Did it work with '?' instead of ':1

RE: Stored Procedure (arguments)

2001-03-12 Thread Peter Loo
declared. 6) I will give DBI-trace a try after I have figured out how it works. Thanks. Peter -Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:38 PM To: Loo, Peter # PHX; [EMAIL PROTECTED] Subject: Re: Stored Procedure (arguments) 1. What