Sytnax error in Proc

[jasonhuibers]

I keep getting error ERROR line 9, col 14, ending_line 9, ending_col 15, Found ':=', Invalid identifier: :=

CREATE OR REPLACE PROCEDURE SYSVIEW.TESTREPORT (V_TEXT IN varchar2) AUTHID CURRENT_USER AS
V_VAR1 VARCHAR2 (12);
v_VAR2 INTEGER;
V_TABLE_NAME VARCHAR(50);

V_TABLE_NAME := 'TABLE_' || V_TEXT;

 

[johnherman]

You could try putting a BEGIN and END around the actual processing SQL. A good habit in any case.

====================================
Sometimes the grass is greener on the other side because there is more manure there - original.

 

[SantaMufasa]

Jason,

As John suggested, the syntax problem relates to missing BEGIN and END keywords:

CREATE OR REPLACE PROCEDURE TESTREPORT (V_TEXT IN varchar2) AUTHID CURRENT_USER AS
 V_VAR1 VARCHAR2 (12);
 v_VAR2 INTEGER;
 V_TABLE_NAME VARCHAR(50);
Begin
 V_TABLE_NAME := 'TABLE_' || V_TEXT;
End;
/

Procedure created.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.