Re: execute immediate

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Tue, 08 Jan 2002 14:13:38 +0000
Message-ID: <3C3AFE92.AD747E4F@exesolutions.com>

Yes. Native Dynamic SQL can process anonymous blocks.

Daniel Morgan

"S.A." wrote:

> 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 - 08:13:38 CST