APEX

I writed this sql query:

select regexp_substr(sys_connect_by_path(child_name,'-'),'[^-]+',1,1) || '-' ||
regexp_substr(sys_connect_by_path(child_name,'-'),'[^-]+',1,2) || '-' ||
regexp_substr(sys_connect_by_path(child_name,'-'),'[^-]+',1,3) d,
child_id r
from test
start with parent_id is null
connect by prior child_id = parent_id;

In APEX 4.0, I write this query "list of values" of Select list item. But, it gave me an error: ORA-00911: invalid character. But query works in SQL Developer program.
Any Suggestion?


CREATE TABLE TEST(
parent_id NUMBER,
child_id NUMBER,
child_name VARCHAR2(50));

INSERT INTO TEST(null, 10, 'ten');
INSERT INTO TEST(10, 6, 'six');
INSERT INTO TEST(10, 4, 'four');
INSERT INTO TEST(4, 3, 'three');
INSERT INTO TEST(4, 1, 'one');