It was indeed how I was declaring the call statement and handling the return value.
Thanks for the help! -----Original Message----- From: Peggy Richter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:10 AM To: JDJList Subject: [jdjlist] RE: JDBC Oracle function question You probably aren't handling the return values. Here's an example that will work: m_Test = (OracleCallableStatement)m_Conn.prepareCall( "begin ? := test_func; end;" ); m_Test.registerOutParameter(1, Types.INTEGER); -----Original Message----- From: Repine, Burt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:55 AM To: JDJList Subject: [jdjlist] JDBC Oracle function question I'm trying to access an Oracle function through JDBC and am not having any success: PLS-00221: 'GET_STORE_INVENTORY' is not a procedure or is undefined I'm doing this the same way I've accessed Oracle procedures successfully in the past, using CallableStatement, etc. Are Oracle functions, as opposed to procedures, taboo and inaccessible or am I missing something? Thanks for any help. ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Be respectful! Clean up your posts before replying ____________________________________________________ ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Be respectful! Clean up your posts before replying ____________________________________________________ ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Be respectful! Clean up your posts before replying ____________________________________________________
