Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

SQLEXEC how do i trap errors from this eg -803 on insert

  • Post reply
2 replies [Last post]
Tue, 10/19/2010 - 10:00am
bosmanjc's picture
bosmanjc
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 07/23/2010
Posts: 14

How do i trap the error after a sqlexec like this one:
SQLExec(SQL.Y_PWD_MGT_SQL_INS_002_A, Y_PWD_MGT_AET.EMPLID); /* insert inactive tl */

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • 5860 reads
Tue, 10/19/2010 - 8:48pm
#1
Lepa's picture
Lepa
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 06/23/2008
Posts: 591
Re: SQLEXEC how do i trap errors from this eg -803 on insert

did you try to wrap that section of code with try and catch?

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
  • reply
Thu, 10/21/2010 - 6:55am
#2
bosmanjc's picture
bosmanjc
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 07/23/2010
Posts: 14
Re: SQLEXEC how do i trap errors from this eg -803 on insert

I did not, as i did not know how to before. I did get some examples. However, the try/catch will prevent the program from failing, but i might want to do something even after the failure. It appears if i do that, i might have to break the app engine step/action into more step/action/action. What do you think?

Top
  • reply

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
1 + 16 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.