SQL> select d.deptno,(select e.ename||' '||d.dname from emp e order by e.empno) ed from dept d
  2  /
select d.deptno,(select e.ename||' '||d.dname from emp e order by e.empno) ed from dept d
                                                         *
ERROR at line 1:
ORA-00907: missing right parenthesis

  1  declare
  2   z_c number;
  3   z_s varchar2(32000) :=
  4  'select d.deptno,(select e.ename||'' ''||d.dname from emp e order by e.empno) ed from dept d'
  5  ;
  6  begin
  7   z_c:=dbms_sql.open_cursor;
  8   dbms_sql.parse(z_c,z_s,2);
  9   dbms_sql.close_cursor(z_c);
 10* end;
SQL> /
declare
*
ERROR at line 1:
ORA-00907: missing right parenthesis
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 8