Question

java.sql.SQLException: ORA-06550: 第 1 行, 第 17 列: PLS-00103: 出现符号 ";"在需要下列之一时： . (

--创建一个包，该包中定义一个游标类型
create or replace package pack1 is
--定义一个游标数据类型
type my_cursor is ref cursor;
end;

--2.编写过程
create or replace procedure pro1
(v_in_deptno in number,v_out_result out pack1.my_cursor) is
begin
open v_out_result for select * from emp where deptno=v_in_deptno;
--为了让java程序可以使用游标，不能在这里关闭游标
end;

java.sql.SQLException: ORA-06550: 第 1 行, 第 17 列:
PLS-00103: 出现符号 ";"在需要下列之一时：
. ( ) , * @ % & | = - + < / >
at in is mod remainder not range rem => .. <an exponent (**)>
<> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_
between || indicator multiset member SUBMULTISET_
符号 ")" 被替换为 ";" 后继续。

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:218)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:971)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3521)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4612)
at com.tiangang.text.Testprocedure2.main(Testprocedure2.java:28)

Answer 1

call pro1( 括号不对称