On Thu, 2002-12-19 at 10:12, Zhao, Charles wrote:
> $database is the name of the database, as it is not included in the data
> source name. On my $server there are dozens of databases so here I
> specify the one where the stored procedure exists.
>
> However, when I do
> $DBH = DBI->connect("dbi:
Have you tried this?
$sth = $dbh->prepare("exec $database..storedProcedure $parm");
On Thu 2002/12/19 10:12:11 PST, "Zhao, Charles" <[EMAIL PROTECTED]> writes
:
> $database is the name of the database, as it is not included in the =
> data
> source name. On my $server there are dozens of databas
;$ap\', \'$tk\' ,
\'$ad\' ,
:output , :out_msg); end;");
I've got 7 input variables here and 2 output ones. You can use
placeholders if you wish.
Tim Vorce
Ford Motor Company
[EMAIL PROTECTED]
-Original Message-----
From: Zhao, Charles [mailto:[EMAI
\' ,
:output , :out_msg); end;");
I've got 7 input variables here and 2 output ones. You can use placeholders if you
wish.
Tim Vorce
Ford Motor Company
[EMAIL PROTECTED]
-Original Message-
From: Zhao, Charles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 200
And some variations, but I always got "no statement executing" msg with
syntax error in the statement preparation.
Any ideas what's wrong with the above?
Thanks a lot.
-Original Message-
From: Brien Pirkle [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 1
iginal Message-
> From: Michael A Chase [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 04, 2002 4:03 PM
> To: [EMAIL PROTECTED]; Zhao, Charles
> Subject: Re: Perl DBI and Stored Procedures
>
>
> On Wed, 4 Dec 2002 15:27:02 -0800 "Zhao, Charles"
> <[EM
Sybase sql servers is what I am using. So far every reply has been very
helpful.
Thanks.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 4:03 PM
To: [EMAIL PROTECTED]; Zhao, Charles
Subject: Re: Perl DBI and Stored Procedures
On
On Wed, 4 Dec 2002 15:27:02 -0800 "Zhao, Charles" <[EMAIL PROTECTED]> wrote:
> I need to call stored procedures directly from Perl -- don't want to use
> any shell script in between. Can anybody please give me any tips how to
> do it?
RTFM: http://xmlproj.com/fom-serve/cache/49.html
For any mor