DDL indead not possible in PLSQL
From: Altasen.com <roel.hogendoorn_at_altasen-dot-com.no-spam.invalid>
Date: Wed, 09 Nov 2005 02:12:06 -0600
Message-ID: <n4Gdna-gL9TLMuzeRVn_vQ_at_giganews.com>
Date: Wed, 09 Nov 2005 02:12:06 -0600
Message-ID: <n4Gdna-gL9TLMuzeRVn_vQ_at_giganews.com>
Indead,
DDL is not possible in PLSQL, and execute immediate works well. Remember: also an automatic commit is done! If you have an older version of the database, you can use the package DBMS_SQL. Hope this helps,
Roel Hogendoorn
More information on Tech Oracle Applications and Tech Oracle can be
found in the Knowledge Base on:
http://www.altasen.com
Received on Wed Nov 09 2005 - 09:12:06 CET