How to Execute PL/SQL in BluePrism

kaushal

New Member
Hi Team,

Hope you all are doing well!

Can someone please suggest how to execute PL/SQL in BluePrism as I'm able to execute simple SQL query but unable run PL/SQL query in BluePrism.
for example please fine below Sample query of PL/SQL which I need to run.

DECLARE
x NUMBER := 100;
BEGIN
FOR i IN 1..10 LOOP
IF MOD(i,2) = 0 THEN -- i is even
INSERT INTO temp VALUES (i, x, 'i is even');
ELSE
INSERT INTO temp VALUES (i, x, 'i is odd');
END IF;
x := x + 100;
END LOOP;
COMMIT;
END;

Your response will be highly appreciated.
Thanks in Advance.
Thanks,
Kaushal
 
Top