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
____________________________________________________
