RE: procedure error

[Bala, Prakash]

You need to use 'Dynamic SQL' in order to drop and create tables. -----Original Message----- From: Lance Prais [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 4:36 PM To: Multiple recipients of list ORACLE-L Subject: procedure error Why in toad when I try to create a stored proc where I drop and create a table I get the following error:    PLS-00103: Encountered the symbol "DROP" when expecting one of the following:    begin function package pragma procedure subtype type use    <an identifier> <a double-quoted delimited-identifier> cur     Here is my code:   CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP (   SOLUTION_ID              VARCHAR2 (85)  NOT NULL,   TITLE                    VARCHAR2 (3498),   OWNER                    VARCHAR2 (255),   P_TYPE                   VARCHAR2 (96),   AUTHOR                   VARCHAR2 (255),   MODIFIED_BY              VARCHAR2 (255),   ESCALATION_GROUP         VARCHAR2 (255),   TECH_RESOURCE            VARCHAR2 (255),   P_PARTITION              VARCHAR2 (96),   STATUS                   VARCHAR2 (96),   HyperLinks                    VARCHAR2 (96),   Style_reviewer             VARCHAR2 (96),   DATE_CREATED             DATE,   DATE_MODIFIED            DATE,   ALERT                    VARCHAR2 (96),   URGENCY                  VARCHAR2 (96),   NO_PAGEVIEWS_LAST_MONTH  VARCHAR2 (255),   NO_PAGEVIEWS_QUARTER     VARCHAR2 (255),   NO_LINKS_LAST_WEEK       VARCHAR2 (255),   NO_LINKS_LAST_MONTH      VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; end; /