using a ddl statement in a stored procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stmfc
    New Member
    • May 2007
    • 65

    using a ddl statement in a stored procedure

    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
  • Saii
    Recognized Expert New Member
    • Apr 2007
    • 145

    #2
    The reason is there is an extra comma after col3.

    Comment

    Working...