Kinook Software Forums

Go Back   Kinook Software Forums > Visual Build Professional > [VBP] General Discussion

Thread Tools Rate Thread Display Modes
Old 10-12-2015, 02:07 PM
mevans mevans is online now
Registered User
Join Date: 04-21-2015
Posts: 31
Reset LASTSTEP_OUTPUT before running action

I have some situations when I'm running an Oracle script and it doesn't work properly. It's not a situation where VBP detects it as an error, so the error handling script isn't run. However, when I try to get LASTSTEP_OUTPUT following the Oracle script, no value has been set. What I appear to be getting is the LASTSTEP_OUTPUT value from the previous call to Oracle.

Is there a way to blank out the LASTSTEP_OUTPUT value prior to running the Oracle step? (or set it to something like "no value retrieved" that I could test after the call whether I got a result?) That would help me see if my theory is correct and may even help me create some error handling routines.

Help says that users cannot set values of system macros, so I haven't bothered trying to set it via script.

At this point, I'm trying to debug the situation. I need to try recreating the problem in a test script so I better understand it. I don't know if I think this is anything that VBP should or could catch as an error yet.
Reply With Quote
Old 10-12-2015, 02:21 PM
kinook kinook is online now
Join Date: 03-06-2001
Location: Colorado
Posts: 5,758
See here for getting sql*plus to return a non-zero exit code on errors (which would cause the Run Oracle Script action to detect and fail the build):*plus+exit+code

The LASTSTEP_OUTPUT system macro should always be updated after each step with the output for that step.
Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

All times are GMT -5. The time now is 06:00 AM.

Copyright 1999-2019 Kinook Software, Inc.