I have created a very simple Oracle stored procedure using Aqua studio. When I execute/alter the code below no errors are displayed and the stored procedure is created. However if I look in Aqua studio under the procedures folder there is a little red symbol next to the stored procedure? If I then try to execute the stored procedure I get an error message in red that looks like below:
So since the stored procedure was actually created, I thought that there were no syntax errors. However, according to the error message,
something is wrong, and I don't know why? Can anyone help me out here, to figure out what is wrong?
DBMS_OUTPUT
> Script lines: 1-1 -------------
ORA-0900 invalid SQL Statement
Script line 1, statement line 1, coumn 0
CREATE OR REPLACE PROCEDURE "NARTI"."myProcedure"
AS
dbNAME VARCHAR(25);
sqlStatement VARCHAR(25);
BEGIN
BEGIN
sqlStatement := 5;
END
DBMS_OUTPUT.PUT_LINE('End of stored procedure myProcedure');
END myProcedure
Our community of experts have been thoroughly vetted for their expertise and industry experience.