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
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