通过传递作为用户输入的sql语句从java调用oracle过程

v09wglhw  于 2021-09-13  发布在  Java
关注(0)|答案(0)|浏览(182)

我正在尝试使用java调用oracle过程。我正在从用户处读取sql查询并将其传递给过程。所以当我想通过的时候 select * from emp where emp_id like 'XX' 作为一条语句,该过程以以下错误结束:-

Error Msg = ORA-06550: line 1, column 103:
PLS-00103: Encountered the symbol "XX" when expecting one of the following:

   ) , * & = - + < / > at in is mod remainder not rem =>
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2
   like4 likec between || multiset member submultiset
The symbol ", was inserted before "XX" to continue.

我怎样才能克服这个问题???
提前谢谢

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题