SQL Anywhere database - failing inside a stored procedure

Author

failing inside a stored procedure

John Davison

2005-04-11, 9:23 am

I'm using SQL Anywhere 9.0.2.2451 with Sybase Central 4.3.0.2387. I
have stored procedures that call other stored procedures, and if
something fails inside one of those stored procedures, the error always
says it fails at line 1 character 1.

Is there any ways to get more information, such as which stored
procedure failed, and what line it failed at?

- john

Rob Waywell

2005-04-14, 9:23 am

Have you tried the Stored Procedure Debugger?

ASA SQL User's Guide

Debugging Logic in the Database

Introduction to debugging in the database

Debugger features

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"John Davison" < johndavison@compasse
ng.com> wrote in message
news:425a75c7@forums
-2-dub...
> I'm using SQL Anywhere 9.0.2.2451 with Sybase Central 4.3.0.2387. I
> have stored procedures that call other stored procedures, and if
> something fails inside one of those stored procedures, the error always
> says it fails at line 1 character 1.
>
> Is there any ways to get more information, such as which stored
> procedure failed, and what line it failed at?
>
> - john

Bruce Hay

2005-04-14, 9:23 am

Take a look at the traceback() function. Executing:
select traceback()
immediately after the error is returned by the procedure call will return a
string showing the statement in error, as well as the procedure calls
leading up to that point.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

"John Davison" < johndavison@compasse
ng.com> wrote in message
news:425a75c7@forums
-2-dub...
> I'm using SQL Anywhere 9.0.2.2451 with Sybase Central 4.3.0.2387. I
> have stored procedures that call other stored procedures, and if
> something fails inside one of those stored procedures, the error always
> says it fails at line 1 character 1.
>
> Is there any ways to get more information, such as which stored
> procedure failed, and what line it failed at?
>
> - john

Sponsored Links