# Execute Immediate

**URL:** <https://forums.toadworld.com/t/execute-immediate/9683>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 12, 2010, 11:29am UTC](https://forums.toadworld.com/t/execute-immediate/9683 "2010-07-12T11:29:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RAFF](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@RAFF](https://forums.toadworld.com/u/RAFF)\
**Post date:** [July 12, 2010, 11:29am UTC](https://forums.toadworld.com/t/execute-immediate/9683/1 "2010-07-12T11:29:30Z")

</div>

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;