[Bug]: Unable to execute sql when the comment in the execution statement includes slash

[Huangxiao-mas]

ODC version

ODC430

OB version

independent

What happened?

Unable to execute sql when the comment in the execution statement includes slash

What did you expect to happen?

。

How can we reproduce it (as minimally and precisely as possible)?

Delimiter $$
create
or replace procedure expro_fzyw_test(v_rettext out clob) as v_addr varchar2(200);
BEGIN
  -- v_addr := 'http://10.85.xx.xx:9936/WebServiceWz/services/callBusiness'; 
  v_rettext := '{"RESPONSECODE":"-3","RESPONSEDESC":"没有传入projid,无法处理"}';
end;
$$

Remove slash ,success exectute it

Delimiter $$
create
or replace procedure expro_fzyw_test(v_rettext out clob) as v_addr varchar2(200);
BEGIN
  -- v_addr := 'http:10.85.xx.xx:9936WebServiceWzservicescallBusiness'; 
  v_rettext := '{"RESPONSECODE":"-3","RESPONSEDESC":"没有传入projid,无法处理"}';
end;
$$

Anything else we need to know?

No response

[zijiacj]

It may be an ob jdbc driver problem. When using two different sql to get the result set, the one that contains the slash will report an error, and the one that does not contain the slash will not

[zijiacj]

The error message is consistent with that exposed by odc

[zijiacj]

This issue has been confirmed with ob R&D and is expected to be fixed at ob jdbc2.4.13