| Help - Errors with CREATE TEMPORARY TABLE and EXECUTE IMMEDIATE - Any help appreciated :) [message #374693] |
Mon, 25 June 2001 09:19  |
Christopher Frankland
Messages: 2
Registered: June 2001
|
Junior Member |
|
|
Hi there,
When attempting to create a temporary table using the procedure below I receive the following errors:
Errors:
(1)PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following:
(1):
(1): :=.(@%;
(1): The symbol ":= was inserted before IMMEDIATE to continue.
My Procedure:
PROCEDURE COPY_TEMPLATE (
IN_MASTER_ID IN NUMBER
)
IS
BEGIN
EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE TEMP_COPY_TEMPLATE(TEMPLATE_DATE DATE)';
END;
Any help would be much appreciated :)
Many thanks,
Chris.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
