Palaka_Bhattacharya

How to combine 2 SQL calls in 1 Policy Xpress action

Discussion created by Palaka_Bhattacharya Employee on Feb 14, 2012
Latest reply on Aug 11, 2017 by Alexey

Contributed by Alexey Vasin (CA Services).

Using Policy Xpress, you can invoke external JDBC code.
JDBC only permits one call per connection, so how do you issue multiple calls to say an Oracle database within the same Policy Xpress action?

Basically, your call should take this form:

BEGIN
Statement1;
Statement2;
END;

This works in Policy Xpress (note the exact placement of the ";" signs).

Outcomes