求助，我这个sql语句 有什么问题

Question

declare
num1 int;
BEGIN

select count(1) into num1 from user_ind_columns where index_name=('IDX_M_ID');
IF num1 >=1 then
dbms_output.PUT_LINE('索引存在');
ELSE
Execute immediate 'create index IDX_M_ID on TRANSACTION_RECORD(M_ID DESC);';
end IF;

select count(1) into num1 from user_ind_columns where index_name=('IDX_IST_TIME');
IF num1 >=1 then
dbms_output.PUT_LINE('索引存在');
ELSE
Execute immediate 'create index IDX_IST_TIME on TRANSACTION_RECORD(IST_TIME DESC);';
end IF;

select count(1) into num1 from user_ind_columns where index_name=('IDX_EVT_TRACE_ID');
IF num1 >=1 then
dbms_output.PUT_LINE('索引存在');
ELSE
Execute immediate 'create index IDX_EVT_TRACE_ID on TRANSACTION_RECORD(EVT_TRACE_ID DESC);';
end IF;
end;

一直报 00911和06512

Answer 1

'create index IDX_M_ID on TRANSACTION_RECORD(M_ID DESC);';字符串里面的分号是不需要，的，
报错有第几行的提示啊，