Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved DBError question

  1. Issue
0
Votes
Undo
  1. Enrique Perez
    Enrique Perez
  2. PowerBuilder
  3. Friday, 9 August 2019 19:25 PM UTC

Hi,

My powerbuilder code calls a stored procedure that call many stored procedures; something like this

proc1->proc2->proc3->......

when there is an error on one of the stored procedures, dberror event is giving me the error code and syntax but no where the error ocurred(procedure name).

Is there any way to know the procedure that triggers the error?

Thanks

enrique

 

PB 2017 doesnot render data on Win10
Unexpected crashes sometime
Responses (3)
Tobias Roth
Tobias Roth Accepted Answer Pending Moderation
  1. Friday, 9 August 2019 21:53 PM UTC
  2. PowerBuilder
  3. # 1

Which database are you using?

In sql anywhere Version 16+ you can use error_stack_trace to get that information.

I used that in procedures, but i think this could also work in powerbuilder. Never tried it. 

http://dcx.sap.com/sa160/en/dbreference/error-stack-trace-function.html

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 9 August 2019 22:19 PM UTC
  2. PowerBuilder
  3. # 2

Hi Enrique;

   If Tobias's suggestion doesn't work for you. Try performing a RaiseError() command and include the procedure's name in the error text. Failing both of the above, have the SP write the error information to the DB log.

Regards ... Chris

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Saturday, 10 August 2019 05:10 AM UTC
  2. PowerBuilder
  3. # 3

Like Chris said, you should always include the name of the procedure AND the actual error code/text in your error messages.

 

Olan

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.