Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Alter View statements in PL/SQL?
I'd really love to be able to create a stored proc that contains a whole
bunch of ALTER VIEW scripts (compile only). Does PL/SQL allow this? I can't
seem to get it into a proc. It blows up on the ALTER.
Any suggestions for a general format of the proc if it is possible?
Thanks.
Was attempting:
Create or Replace Procedure TEST_COMP_VIEWS() as
Begin
alter view prod.v_view_name1 compile; alter view prod.v_view_name2 compile; alter view prod.v_view_name3 compile;End; Received on Mon Sep 30 2002 - 16:07:29 CDT
![]() |
![]() |