Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Multiple records fetches issue using DBD::ODBC in Perl

by jo37 (Hermit)
on Apr 17, 2020 at 18:36 UTC ( #11115698=note: print w/replies, xml ) Need Help??


in reply to Multiple records fetches issue using DBD::ODBC in Perl

This problem might be related to a stored procedure as the statement to be executed. Is there a way to define a view that gives the same result and to use a select on this view to get the result set? Maybe this could help narrowing the problem.

Greetings,
-jo

$gryYup$d0ylprbpriprrYpkJl2xyl~rzg??P~5lp2hyl0p$
  • Comment on Re: Multiple records fetches issue using DBD::ODBC in Perl

Replies are listed 'Best First'.
Re^2: Multiple records fetches issue using DBD::ODBC in Perl
by maria80e (Novice) on Apr 20, 2020 at 10:31 UTC

    I have set DBI TRACE=1 and executed the code.

    my $result = $sql->execute() or die "Couldn't execute statement: " . $sql->errstr;

    after sql->execute it prints the value as -1.

    Actually, I am doing perl upgrade, The existing code has used MSSQL::DBLIB,MSSQL::SQLLIB to execute the stored procedures (MS SQL SERVER)which are deprecated in the higher version.For Windows platform i have used DBI,DBD::ODBC module to connect the Database and execute the stored procedure.

    Note: Database connection and stored procedure execution was working fine in perl old version(20 yrs old)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11115698]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (1)
As of 2022-05-20 23:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (76 votes). Check out past polls.

    Notices?