P_REQ_ID NUMBER;
P_SQL VARCHAR2(1000);
BEGIN
P_REQ_ID := 1397;
P_SQL := ‘INSERT INTO LRT_EXTRACT_INV_STAGE VALUES (:REQ_ID)’;
COMMIT;
Trying to get a simple Execute Immediate to work. Not getting any errors, it’s just not hitting the table. REQ_ID is the name of the column in the table. P_REQ_ID is the variable storing the value. Any ideas?
Thanks in advance!
Mike
EXECUTE IMMEDIATE P_SQL USING P_REQ_ID;