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>
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