OraFAQ Forum: Server Administration » Help - Errors with CREATE TEMPORARY TABLE and EXECUTE IMMEDIATE

Home » RDBMS Server » Server Administration » Help - Errors with CREATE TEMPORARY TABLE and EXECUTE IMMEDIATE - Any help appreciated :)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator