Sometimes,if comment line has chinese,F8 to autoselect statement will fail.

[oracle developer]

F8 to autoselect current statement is very well,but sometimes,press F8 to run current ,and PL/SQL Dev select the error sql text to run,so it report error.

Please fix it.

 

[oracle developer]

Sometimes,It seems PL/SQL DEV has autoselect correct sql,but it still run failly,and if copy the sql to other window,perhaps it runs correctly.

[color=#red]
At last, I add a newline at the sql's last line,then F8 can autoselect and run it.
[/color]

 

[Marco Kalter]

Can you send me a SQL script to reproduce the error?

 

[oracle developer]

Originally posted by Marco Kalter:
Can you send me a SQL script to reproduce the error?

send to this email address: support@allroundautomations.com ?

 

[oracle developer]

have sent to support@allroundautomations.com :

Place cursor into :
select gn_dm,
mc,
gns_lx
from t_xt_gns
where cd_lx = '0' and
mc like '%登记%';

and F8,PL/SQL DEV report error: Error while trying to retrieve text for error ORA-01756

Place cursor into the last sql:
SELECT ry.swry_dm || ry.mc 人员,
ry.swjg_dm || jg.mc 所在部门,
(SELECT jg2.swjg_dm || jg2.mc
FROM t_dm_gy_swjg jg2
WHERE jg2.swbm_bj = '0' AND
rownum = 1
START WITH jg2.swjg_dm = jg.swjg_dm
CONNECT BY PRIOR sjswjg_dm = jg2.swjg_dm) 所在机构
FROM t_dm_gy_swjg jg,
t_dm_gy_swry ry
WHERE ry.swry_dm IN ('24420000282') AND
ry.swjg_dm = jg.swjg_dm;

and F8,PL/SQL DEV report error: ORA-00904: "JG"."SWJG_D": invalid identifier

and If add a newline behind :ry.swjg_dm = jg.swjg_dm;
then F8 will be ok.