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
