oracle 函数里建表报错，请高手指点

Question

CREATE OR REPLACE FUNCTION aa (n IN VARCHAR2)
   RETURN NUMBER
AS
BEGIN
   EXECUTE IMMEDIATE    'CREATE TABLE bb'
                     || n
                     || '
                         (
                            cc                         int                                 NOT NULL,                     
                            dd                        varchar2              (20)          NOT NULL,
                          )';   RETURN 1;
END;EXEC dbms_output.put_line(aa('2'));

Answer 1

发表于：2008-08-19 17:56:49天啊  怪不得没有人回答 问题点数:0