when i use a ddl statement in a stored procedure
i got an invalid identifier error if my stored procedure
accepts an input parameter.
when i remove this input parameter there is not any problem.
does it make sense?
or am i missing a point?
CREATE OR REPLACE PROCEDURE myproc1 (total_number IN NUMBER )
AS
BEGIN
EXECUTE IMMEDIATE 'create table deneme1 (
col1 NUMBER,
col2 NUMBER,
col3 VARCHAR2(30),
)';
END;
/
exec myproc1(2);
ERROR at line 1:
ORA-00904: : invalid identifier
ORA-06512: at "SYSADM.MYPROC1 ", line 4
ORA-06512: at line 1
i got an invalid identifier error if my stored procedure
accepts an input parameter.
when i remove this input parameter there is not any problem.
does it make sense?
or am i missing a point?
CREATE OR REPLACE PROCEDURE myproc1 (total_number IN NUMBER )
AS
BEGIN
EXECUTE IMMEDIATE 'create table deneme1 (
col1 NUMBER,
col2 NUMBER,
col3 VARCHAR2(30),
)';
END;
/
exec myproc1(2);
ERROR at line 1:
ORA-00904: : invalid identifier
ORA-06512: at "SYSADM.MYPROC1 ", line 4
ORA-06512: at line 1
Comment