sql server 2000 and stored proc returning cursor to perl
From: Ozgur Demirtas (Ozgur.Demirtas_at_stramit.com.au)
Date: 10/14/03
- Next message: Christopher Grey: "Perl with Oracle 9.2"
- Previous message: Tim Bunce: "Re: MYSQL where clause case sensitive?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 14 Oct 2003 19:28:31 +1000 To: "DBI users" <dbi-users@perl.org>
hi,
I am trying to run a stored procedure in Microsoft SQL 2000. The stored
procedure is supposed to return a cursor back to perl. In the code
below I am unable to find the codes I have marked with "?". I assume,
the "?" represent the DBIC cursor data type and I can not seem to find the code
for it. Do you think it might be sql server 2000 specific or there is a DBI code
for it?
use DBI;
use DBD::ODBC;
my $db = DBI->connect ....
my $retValue1;
my $sth = $db->prepare("{call proc_Main (?)}");
$sth->bind_param_inout(1,\$retValue1, ?);
$sth->execute or die "Error executing the statement: $DBI::errstr";
When I run this code I get:
Error executing the statement: [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: int is incompatible with cursor (SQL-22018)(DBD: st_execute/SQLExecute err=-1)
If you have done a similar job, I appreciate an input.
Thanks,
Ozgur
- Next message: Christopher Grey: "Perl with Oracle 9.2"
- Previous message: Tim Bunce: "Re: MYSQL where clause case sensitive?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
