Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 10-12-2015, 01:07 PM
mevans mevans is offline
Registered User
 
Join Date: 04-21-2015
Posts: 32
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
  #2  
Old 10-12-2015, 01:21 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
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):
https://www.google.com/search?q=sql*plus+exit+code

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


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 02:27 AM.


Copyright © 1999-2023 Kinook Software, Inc.