Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Alter View statements in PL/SQL?

Alter View statements in PL/SQL?

From: Cynic <sdkfj_at_yahoo.com>
Date: Mon, 30 Sep 2002 17:07:29 -0400
Message-ID: <uphf5i9utikbd9@corp.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US