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
Satheesh.A
Messages: 9
Registered: May 2016
Location: Chennai
Junior Member
Can anyone pls explain why we cannot use DDL commands in Procedure??

Report message to a moderator

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: 9002
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.

Report message to a moderator

Re: DDL commands [message #651998 is a reply to message #651991] Tue, 31 May 2016 02:06 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 02 22:19:13 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.