Calling stored procs from Perl

[c0l1n]

We're getting a perculiar problem calling certain sprocs from perl 5.6 (calling from isql, odbc etc seems fine). Occasionally, the proc will hang or run very slowly. It isn't to do with the query plan of the proc, as it can be re-run (even while the hung proc is still running, and even from Perl) and it re-runs fine. It doesn't seem to be anything to do with resources being locked , the machine is idle, it doesn't happen every time and eventually it will complete...

anyone got any ideas?

 

[qyllr]

hello,

try running the sp with recompile and see if there's a change...

i use the sybperl.pm module and it works great with sybase...

hth,
q.