Re: HELP on PL/SQL problem
Date: Sat, 04 Mar 95 14:17:13 GMT
Message-ID: <3j9skb$den_at_steel.interlog.com>
In article <3j3um6$mul_at_polo.iquest.com>, brink_at_iquest.com says:
>
>Is it possible to execute a dynamic SQL statement from PL/SQL?
>
>I want to build an SQL statement on the fly and execute it as in the following
>example.
>
>CREATE OR REPLACE PROCEDURE SYNC_ALL (arg IN NUMBER) is
> sqlStmt CHAR(255);
>BEGIN
> sqlStmt := 'insert into tableName values (1,2,3)';
> EXECUTE IMMEDIATE :sqlStmt;
>END SYNC_ALL;
>
>Our local site ORACLE support says PL/SQL does not support dynamic
>SQL? Is this true? Any suggestions appreciated.
>
Does this method of executing SQL statements support DDL statements? Would I be able to create or drop tables that exist outside the scope of the procedure?
Doug.
/* Opinions expressed in the body of this message may not be my own.
They may have been forced upon me by my employer. */ Received on Sat Mar 04 1995 - 15:17:13 CET