ORA-00911: invalid character ... why
AyhamJun 8 2012 — edited Jun 8 2012Hi all,
when i execute the follwoing PL/SQL block , the error message say
ORA-00911: invalid character
begin
execute immediate 'create table test as select to_number(regexp_substr(doc_list'
||' , '
||' ''[^,]+'', 1, level) from test;'
end;
but in SQL running ok :
select to_number(regexp_substr(doc_list, '[^,]+', 1, level)) val from test
regards
Wael