Roger,
Thank you v. much. This is exactly the info I was looking for.
Rgds,
Brien
-Original Message-
From: Roger Perttu
To: Brien Pirkle; '[EMAIL PROTECTED] '
Sent: 28/11/02 16:47
Subject: Re: Calling SQLServer Stored Procedures
Brien Pirkle wrote:
>Jeff,
>
>
Brien Pirkle wrote:
Jeff,
So, assuming sp_foo takes no paramters, my whole script could be:
#
use DBI;
my $dbh = DBI->connect('DBI:ODBC:OSTDB', 'user', 'password')
or die "Couldn't connect to database: " . DBI->errstr;
{call sp_foo}
#More like this:
str;
{call sp_foo}
#
Rgds,
Brien
-Original Message-
From: Jeff Urlwin
To: Brien Pirkle; [EMAIL PROTECTED]
Sent: 28/11/02 14:55
Subject: RE: Calling SQLServer Stored Procedures
>
> How can I execute a SQL Server stored proc from my Perl script?
> Th
>
> How can I execute a SQL Server stored proc from my Perl script?
> The Cheeta
> book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape
> sequence:
>
> {call procedure1_name}
>
> Fine. But what's the rest of the syntax?
Err, that is the syntax. If your procedure name is
Brien Pirkle wrote:
How can I execute a SQL Server stored proc from my Perl script? The Cheeta
book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape
sequence:
{call procedure1_name}
Fine. But what's the rest of the syntax?
From BOL:
The ODBC CALL escape sequence for call