Kinook Software Forums

Kinook Software Forums (http://www.kinook.com/Forum/index.php)
-   [VBP] General Discussion (http://www.kinook.com/Forum/forumdisplay.php?f=2)
-   -   Reset LASTSTEP_OUTPUT before running action (http://www.kinook.com/Forum/showthread.php?t=5380)

mevans 10-12-2015 02:07 PM

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.

kinook 10-12-2015 02:21 PM

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.


All times are GMT -5. The time now is 05:30 PM.


Copyright 1999-2019 Kinook Software, Inc.