Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
March 30, 2009, 9:11 am
rate this thread
database (connect, prepare, execute, fetchrow_arrayref, finish, etc).
The SP needs to:
- INSERT a record using arguments it got
- return result codes using a SELECT statement
If the SP SELECTs anything, even a constant value (e.g. SELECT "OK")
BEFORE the INSERT,
the calling Perl script gets the result.
If the SP SELECTs anything AFTER the INSERT,
no result comes back.
I do see in the DB that the INSERT succeeded though.
Any clue why INSERT might have such side effect?
Re: Calling SQL Server Stored Procedures: no results from SELECT following INSERT
SELECTS that follow INSERT?
Is it possible that only one dataset may come back from SP, and that
INSERT results in an
empty dataset, in that way blocking results from following SELECTs?
- » Re: FAQ 3.10 Is there an IDE or Windows Perl Editor?
- — Next thread in » PERL Discussions