in reply to Errors in stored procs with Sybase and DBI

Hmmm - this works correctly for me: 
Establishing connection to DB testdb
RaiseError=0 PrintError=0 Value=1
Got an inline error:
MYERROR: Can't execute statement: Server message number=9999000 severi
+ty=16 state=1 line=7 server=troll procedure=check_error_return text=T
+hrowing error as @throw='1' at /tmp/raise2.pl line 27.
RaiseError=0 PrintError=0 Value=null

[download]
I have admittedly the CVS version of DBD::Sybase, but I don't remember making any changes to handle this specific problem.

Which version of DBD::Sybase are you running?

Michael

Replies are listed 'Best First'.
Re: Re: Errors in stored procs with Sybase and DBI
by demerphq (Chancellor) on Dec 11, 2003 at 18:43 UTC

    Hi Michael. Im running DBD::Sybase 0.91 on Win2k with Sybase 12.5 on AS Perl 635.

    Ill look into upgrading, but alas this is the same version as on our production boxes.

    Thanks for the assitance though.


    ---
    demerphq

      First they ignore you, then they laugh at you, then they fight you, then you win.
      -- Gandhi

[reply]
[d/l]
      Oh my... 0.91 is pretty ancient. The current version is 1.01.

      I know that upgrading things can be difficult in a production environment, but in this case I think it would really help - there have been a lot of fixes and enhancements.

      Michael

[reply]

        Yep. That did the trick nicely. Version 1.01 works as expected. Looks like im going to have to upgrade that production machine. Sigh.

        Thanks Michael.


        ---
        demerphq

          First they ignore you, then they laugh at you, then they fight you, then you win.
          -- Gandhi

        • Update:  
        I forgot to mention: The latest version of Sybase available from ActiveState via ppm is 0.91. It may be worth suggesting they upgrade. I would give them a copy of my binaries, but I understand that there are issues using VC7 generated DLL's on machines without the correct MSVCRT.dll (this is hearsay, ive not investigated)


[reply]
[d/l]

In Section Seekers of Perl Wisdom