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
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
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
]; "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
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
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
('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
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 #
"'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
]'
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(:
'; 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
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
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
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
: 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
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
16 matches
Mail list logo