LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

is it possible to access the SQLCA on an Oracle database operation?

  • 1.  is it possible to access the SQLCA on an Oracle database operation?

    Employee
    Posted 02-17-2014 11:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: MountainSteve

    Is there some way in Lavastorm to access the SQL Communications Area on an Oracle database operation? Specifically, I'd like to be able to check the value of SQLCODE (return code from the operation) and SQLERRM (to obtain the text of an error message), if it's possible. I know that Lavastorm generically tells you if a database node completed successfully or not, but it would be nice to have more extensive information available (for example: if the database connection is down) so that I could determine downstream workflow based on that information? Thanks.