Re: Stored procedure support?
"Richard N. Fogle" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <004401c667fd$fef82560$0302a8c0@rfogle> |
Yes, we're re-writing our queries into SPs like the norm for Oracle development.. I wrote several, the cursors are a bit limited but it is 'good enough' for most of what we have. I called an SP using $dbh->do() and preparing a statement, I received what is talked about in this thread: http://forums.mysql.com/read.php?51,63934,63960#msg-63960 Since that was almost a year ago I figured that the changes/fixes were out there and I was simply missing it. I'd be ok writing a HOWTO, but the functionality isn't there. Rich ----- Original Message ----- From: Jake Peavy Did you try it? If so, what happened? I haven't used SP's yet either, but I assume, if the user you're connecting to the server as has the appropriate permissions, you will just execute the SP with $dbh->do( 'stored_procedure' ). But, in order to test my theory, I'd write a basic SP (like one that inserts NOW() into a test table) and then write a quick 10-line Perl script to test it. Either that or you could harass the general public until they write a nice tidy HowTo response to your question... Up to you... -- -jp When Chuck Norris exercises, the machine gets stronger.