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;
/