[Oracle JDBC Driver][Oracle]ORA-06575:

java.sql.SQLException: [Oracle JDBC Driver][Oracle]ORA-06575: Package or function FETCHCHARACVALUE is in an invalid state
我创建的存储过程是
Create or Replace procedure fetchValue(Aid in varchar2, Bid varchar2, p_cursor out types.cursorType)
As
Begin
select rcv.requestid, c.datatype, c.characid, cv.color, cv.datetimevalue, cv.intvalue, cv.stringvalue from charac c, value cv, request rcv
where c.characid = cv.characid and cv.characvalueid = rcv.characvalueid and cv.characid in (Aid) and rcv.requestid in Bid;
End fetchValue;
希望返回数据集合
Java 代码是
String driver_class = "oracle.jdbc.driver.OracleDriver";
String connect_string = "jdbc:oracle:thin:@localhost:1521:DB";
String query = "call fetchCharacValue(?,?,?)";
Connection conn;
Class.forName(driver_class);
conn = DriverManager.getConnection(connect_string,"USER","PASS");
CallableStatement cstmt = con.prepareCall(query);
cstmt.setString(1, AId);
cstmt.setString(2, BID);
cstmt.registerOutParameter(3,OracleTypes.CURSOR);
cstmt.execute();
cvrs = (ResultSet)cstmt.getObject(3);
求高手解决

Package or function FETCHCHARACVALUE is in an invalid state
翻译：你的函数处在非法状态，也就是函数编译不成功，无法引用。

ora-12505解决2010-09-09 22:41在使用oracle时遇到了一个问题： ora-12505, tns:listener does not currently know of sid given in connect descriptor the connection descriptor used by the client was: localhost:1521:orcl 查阅了很多网上的内容，知道了是oracle 的sid注册有问题。 按照网上的步骤解决如下： 1.在oracle目录下查找listener.ora文件,修改成如下格式的： # listener.ora network configuration file: d:\oracle10g\network\admin\listener.ora # generated by oracle configuration tools. sid_list_listener = (sid_list = (sid_desc = (sid_name = plsextproc) (oracle_home = d:\oracle10g) (program = extproc) ) (sid_desc = (global_dbname = orcl) (oracle_home = d:\oracle10g) (sid_name = orcl) ) ) listener = (description_list = (description = (address = (protocol = ipc)(key = extproc1)) (address = (protocol = tcp)(host = localhost)(port = 1521)) ) )