Home » SQL & PL/SQL » SQL & PL/SQL » DDL commands (oracle 11g)
DDL commands [message #651991] Tue, 31 May 2016 01:45 Go to next message
Messages: 9
Registered: May 2016
Location: Chennai
Junior Member
Can anyone pls explain why we cannot use DDL commands in Procedure??
Re: DDL commands [message #651995 is a reply to message #651991] Tue, 31 May 2016 01:53 Go to previous messageGo to next message
John Watson
Messages: 8580
Registered: January 2010
Location: Global Village
Senior Member
PL/SQL is statically compiled. It would be logically impossible to compile code that has dependencies on an object that would itself be re-complied during execution.
Re: DDL commands [message #651998 is a reply to message #651991] Tue, 31 May 2016 02:06 Go to previous message
Michel Cadot
Messages: 67923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But you can.

Please feedback in your previous topic: http://www.orafaq.com/forum/m/651916/#msg_651916.

[Updated on: Tue, 31 May 2016 02:07]

Report message to a moderator

Previous Topic: Reverse row to column and column to row
Next Topic: Loops
Goto Forum:

Current Time: Thu Jul 29 23:23:04 CDT 2021