Toad World® Forums

Execute Immediate


#1

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;