Hello, guys.
I am trying to run PL/SQL from Pipeline Pilot.
When I run it in SQL Developer, SQL Plus, etc. there is output, but not from the component.
No errors occur in the component, but no data records flow either.
What should I do?
This is my Protocol.
It is a minimal state that can reproduce the phenomenon(DB schema creation, etc. not included.).
This is my dummy data.
-- create DB obj...
CREATE TABLE DATA_DEF (
DATA_ID raw (16) DEFAULT SYS_GUID() NOT NULL,
DATA_NAME VARCHAR2 (50) NOT NULL,
PRIMARY KEY (DATA_ID)
);
-- insert data...
INSERT INTO DATA_DEF ( DATA_NAME ) VALUES ( 'Which' ) ;
INSERT INTO DATA_DEF ( DATA_NAME ) VALUES ( 'country' ) ;
INSERT INTO DATA_DEF ( DATA_NAME ) VALUES ( 'would you' ) ;
INSERT INTO DATA_DEF ( DATA_NAME ) VALUES ( 'like' ) ;
INSERT INTO DATA_DEF ( DATA_NAME ) VALUES ( 'to go' ) ;
This is my PL/SQL.
I would run this by the component.
DECLARE
v_id VARCHAR2(50);
v_sql VARCHAR2(4000);
BEGIN
-- get id from Protocol
v_id := 'F2A549E00118448083EF9E3FC3F30A19';
-- generate SQL
v_sql := 'SELECT DATA_ID, DATA_NAME FROM DATA_DEF WHERE DATA_ID = :1';
-- check var
DBMS_OUTPUT.PUT_LINE(v_sql);
DBMS_OUTPUT.PUT_LINE(v_id);
-- execute SQL
-- I want to get this results.
EXECUTE IMMEDIATE v_sql USING v_id;
END;