Create or Replace in PL\SQL

[cfcProgrammer]

Hi
I am trying to create a view within a stored proc but I am getting an error while doing this. I have never created a view on the fly within a procedure before... Is this even allowed?

This is the error I am getting:
[COLOR=blue lightblue]
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier> [/color]

Thank you in advance for your help
cfcProgrammer

 

[Beilstwh]

You can't run DDL commands in native sql without execute immediate. For example

begin
execute immediate create view my_view as select col1,col23 from my_table;
end;




Bill
Oracle DBA/Developer
New York State, USA

 

[Dagon]

Er..you might need quotes around it as well:

begin
execute immediate 'create view my_view as select col1,col23 from my_table';
end;

 

[cfcProgrammer]

Thank you so much... greatly appreciated...