If it’s inserting datatable then we can directly use INSERT activity instead of EXECUTE QUERY activity
Or try with EXECUTE NON QUERY activity instead of EXECUTE QUERY activity, as it is the one meant for insert statement and we can Choose the type
Of statement we want in SQL property panel https://docs.uipath.com/activities/docs/execute-non-query
"SET SERVEROUTPUT ON;
DECLARE
TYPE slsorder_tab IS TABLE OF VARCHAR2 (2000);
slsorder slsorder_tab := slsorder_tab ();
CNT VARCHAR2(10):= 0;
BEGIN
SELECT esd.EXTERNAL_SYSTEM_ID
BULK COLLECT INTO slsorder
FROM external_system_data esd
LEFT OUTER JOIN proxy_instance_status pis
ON esd.EXTERNAL_SYSTEM_ID = TO_CHAR (pis.owner_id)
WHERE esd.EXTERNAL_SYSTEM_ID IN (SELECT TO_CHAR (ORDER_ID)
FROM ord_view@VOMWFPL
WHERE ORDER_TYPE_CD = ‘SLS’
AND ORDER_STATUS_CD = ‘OPN’)
AND esd.OWNER_TYPE = ‘ORDER’
AND esd.MAPPING_CLOSE_DATE IS NULL
AND pis.owner_id IS NULL
AND esd.EXTERNAL_SYSTEM_NAME = ‘OES’;
FOR i IN 1 … slsorder.COUNT
LOOP
IF slsorder.EXISTS (i)
THEN
DBMS_OUTPUT.put_line (slsorder (i));
"SET SERVEROUTPUT ON;
DECLARE
TYPE slsorder_tab IS TABLE OF VARCHAR2 (2000);
slsorder slsorder_tab := slsorder_tab ();
CNT VARCHAR2(10):= 0;
BEGIN
SELECT esd.EXTERNAL_SYSTEM_ID
BULK COLLECT INTO slsorder
FROM external_system_data esd
LEFT OUTER JOIN proxy_instance_status pis
ON esd.EXTERNAL_SYSTEM_ID = TO_CHAR (pis.owner_id)
WHERE esd.EXTERNAL_SYSTEM_ID IN (SELECT TO_CHAR (ORDER_ID)
FROM ord_view@VOMWFPL
WHERE ORDER_TYPE_CD = ‘SLS’
AND ORDER_STATUS_CD = ‘OPN’)
AND esd.OWNER_TYPE = ‘ORDER’
AND esd.MAPPING_CLOSE_DATE IS NULL
AND pis.owner_id IS NULL
AND esd.EXTERNAL_SYSTEM_NAME = ‘OES’;
FOR i IN 1 … slsorder.COUNT
LOOP
IF slsorder.EXISTS (i)
THEN
DBMS_OUTPUT.put_line (slsorder (i));
Then try like keeping these in a PROCEDURE and just mention the procedure name within double quotes in EXECUTE NON QUERY ACTIVITY so that this activity will call the procedure And execute all those statements
if i remove “SET SERVEROUTPUT ON” this from first line it is executing the query
This is the key. I missed it in my previous searches. It’s not only that Studio / Run command activity ignores it, but trying to run whatever piece of PL/SQL starting with this will fail.