帮忙看看Oracle语句什么问题~~！

Question

create or replace procedure p_createtable authid current_user as begin execute immediate 'create database netmaster50'; end p_createtable;
-- -------------------------------------------------------------
-- table: ns_ability_resource                                 
-- -------------------------------------------------------------
create table ns_ability_resource  (
   resource_id        varchar2(128)                   not null,
   category_id        varchar2(128)                  default null,
   resource_url       varchar2(100)                  default null,
   resource_type      char(1)                        default null,
   constraint pk_ns_ability_resource primary key (resource_id)
);-- -------------------------------------------------------------
-- table: ns_accessuserconfig                                
-- -------------------------------------------------------------
create table ns_accessuserconfig  (
   id                 varchar2(128)                  default '' not null,
   unitid             varchar2(128)                  default null,
   constraint pk_ns_accessuserconfig primary key (id)
);-- -------------------------------------------------------------
-- table: ns_alarm_mail                                       
-- -------------------------------------------------------------
create table ns_alarm_mail  (
   alarmid            varchar2(32)                    not null,
   mailid             varchar2(32)                    not null
----   constraint fkf8f1799fee4bd926  (mailid),
----   constraint fkf8f1799fd000bb9e  (alarmid) 
);-- -------------------------------------------------------------
-- index: fkf8f1799fee4bd926                                  
-- -------------------------------------------------------------
create index fkf8f1799fee4bd926 on ns_alarm_mail (
mailid
);-- -------------------------------------------------------------
-- index: fkf8f1799fd000bb9e                                  
-- -------------------------------------------------------------
create index fkf8f1799fd000bb9e on ns_alarm_mail (
alarmid
);-- -------------------------------------------------------------
-- table: ns_alarm_netsend                                    
-- -------------------------------------------------------------
create table ns_alarm_netsend  (
   unitid             varchar2(128)                   not null,
   alarmid            varchar2(32)                    not null
);-- -------------------------------------------------------------
-- table: ns_alarm_phone                                      
-- -------------------------------------------------------------
create table ns_alarm_phone  (
   alarmid            varchar2(32)                    not null,
   phoneid            varchar2(32)                    not null
----   constraint fk256b4686d000bb9e unique (alarmid),
----   constraint fk256b468674548b36 unique (phoneid),
----   constraint fk256b46868656ddba unique (phoneid)
);-- -------------------------------------------------------------
-- index: fk256b4686d000bb9e                                 
-- -------------------------------------------------------------
create index fk256b4686d000bb9e on ns_alarm_phone (
alarmid
);-- -------------------------------------------------------------
-- index: fk256b468674548b36                                  
-- -------------------------------------------------------------
create index fk256b468674548b36 on ns_alarm_phone (
phoneid
);-- -------------------------------------------------------------
-- table: ns_alarm_sound                                      
-- -------------------------------------------------------------
create table ns_alarm_sound  (
   alarmid            varchar2(32)                    not null,
   soundid            varchar2(32)                    not null
----   constraint fk2598d227472410d4 unique (soundid),
----   constraint fk2598d227d000bb9e unique (alarmid),
----   constraint fk2598d22712f18158 unique (soundid)
);
[Err] ORA-24344: success with compilation error

Answer 1

show errors 看看具体什么错误？

Answer 2

create or replace procedure p_createtable 
authid current_user 
as 
begin 
execute immediate 'create database netmaster50'; 
end p_createtable;
又混了MSSQL 的写法 你这是要干什么