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

Home -> Community -> Usenet -> c.d.o.server -> execute immediate

execute immediate

From: S.A. <adenwalaNO_SPAM_at_att.com>
Date: Tue, 8 Jan 2002 14:24:31 -0500
Message-ID: <a1ffov$ejl11@kcweb01.netnews.att.com>


Is it possible to execute two statements in one call to execute immediate?

for example;
declare

string_to_execute                long;

begin
string_to_execute := 'create view test_view on test_table
/

grant select on test_view to power_users'

execute immediate string_to_execute;
end;
/

thanks for any help.
My environment: 8.1.7 enterprise edition on sun solaris. Received on Tue Jan 08 2002 - 13:24:31 CST

Original text of this message

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