HELP on PL/SQL problem
From: <brink_at_iquest.com>
Date: 2 Mar 1995 08:12:54 GMT
Message-ID: <3j3um6$mul_at_polo.iquest.com>
Date: 2 Mar 1995 08:12:54 GMT
Message-ID: <3j3um6$mul_at_polo.iquest.com>
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;