Need help with Oracle syntax
Posted on 2016-10-05
ORA-00900 : invalid SQL statement
Script line 3, statement line 1, column 0
I can create the simple stored procedure below. However if I try an execute it, I get the error messages shown below. I need
an ORACLE expert to tell me what I am doing wrong? I have not been able to figure it out?
CREATE OR REPLACE PROCEDURE "CMUDEMO"."GenerateSummaryData"
DECLARE dbName VARCHAR(25);
DECLARE TableName VARCHAR(25);
TableName := 'CUST_PURCHASES';