Adding a column to a table using a PL/SQL Procedure or Function.
Hello All,
Do anyone know how to do this? Seems like when I do it I get an error that says, "[Error]Syntax check , Found 'table', Expecting: ; -or - :="
My code is simple like this, i get the same error whether it is a function or a procedure.
CREATE OR REPLACE FUNCTION APPS.nlas_add_cols
RETURN NUMBER AUTHID CURRENT_USER AS
BEGIN
alter table nlas_bdgt_loading_stg add NEW_VALUE Number;
RETURN (0);
END nlas_add_cols;
/
Do anyone know how to do this? Seems like when I do it I get an error that says, "[Error]Syntax check , Found 'table', Expecting: ; -or - :="
My code is simple like this, i get the same error whether it is a function or a procedure.
CREATE OR REPLACE FUNCTION APPS.nlas_add_cols
RETURN NUMBER AUTHID CURRENT_USER AS
BEGIN
alter table nlas_bdgt_loading_stg add NEW_VALUE Number;
RETURN (0);
END nlas_add_cols;
/
0