Re: Execute Immediate

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 30 Jul 2001 12:01:42 -0700
Message-ID: <3B65AF16.3324FC67_at_attws.com>


Scott Mattes wrote:

> I need to know if this is available for use in procedures in Forms
> 6.0.8.12.1, or not. I know that when I try it I get an error saying
> something to the effect "found immediate, expecting one of the
> following".

Not sure but if it isn't there is a simple workaround.

Create a stored procedure something like this (this is very simplified just to show the idea).

CREATE OR REPLACE PROCEDURE eximmed (stringin VARCHAR2) IS

BEGIN
   EXECUTE IMMEDIATE stringin;

END; Daniel A. Morgan Received on Mon Jul 30 2001 - 21:01:42 CEST

Original text of this message