brgdotnet
asked on
Need help with Oracle syntax
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"."GenerateSummary Data"
AS
DECLARE dbName VARCHAR(25);
DECLARE TableName VARCHAR(25);
TableName := 'CUST_PURCHASES';
BEGIN
END;
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"."GenerateSummary
AS
DECLARE dbName VARCHAR(25);
DECLARE TableName VARCHAR(25);
TableName := 'CUST_PURCHASES';
BEGIN
END;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you provide more details like what you are trying to achieve here , may be the logic you wanted to achieve in the proc?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.