I have clob variable which is storing the sql statement to execute and I am assigning the sql output in table type object.

EXECUTE IMMEDIATE v_sql BULK COLLECT INTO result_table;

CREATE OR REPLACE TYPE LOOKUP_RECORD AS OBJECT (
op_unit VARCHAR2(100),
region VARCHAR2(100),
part_no VARCHAR2(50),
inv_org VARCHAR2(50)
);
CREATE OR REPLACE TYPE LOOKUP_TABLE AS TABLE OF LOOKUP_RECORD;

getting not all Variable bound Error while calling the fucntion
kindly suggest how can I debug to fix this

it should call the execute immediate statement and store the output of v_sql in result_table.