tag:blogger.com,1999:blog-7030997386028100204.post4430339446460414262..comments2022-12-04T20:36:24.354-08:00Comments on <a href="http://harpoontech.com">Harpoon Technologies</a>: Using Oracle Stored Procedures and Java ResultSetRajesh Patelhttp://www.blogger.com/profile/11070763300226168187noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7030997386028100204.post-80900153400975054992016-10-06T12:42:29.045-07:002016-10-06T12:42:29.045-07:00thanks!thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-63310500680038382932016-04-20T06:19:41.232-07:002016-04-20T06:19:41.232-07:00This was a great help :) thanx again this is the o...This was a great help :) thanx again this is the only exMPLE that was simple and yet Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-63623969343901988432016-01-07T09:34:22.522-08:002016-01-07T09:34:22.522-08:00I am actually calling java code from within javasc...I am actually calling java code from within javascript, so there is no casting in step 4 since everything is var in javascript.<br />Any ideas would be greatly appreciated.StickyBandithttps://www.blogger.com/profile/08708309679599198684noreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-87598171085366444872015-12-11T12:13:33.467-08:002015-12-11T12:13:33.467-08:00I tried this code and get the following error.
In...I tried this code and get the following error.<br /><br />InternalError: Cannot convert [JavaPackage com.oracle.OracleType.CURSOR] to java.lang.Integer (dba9d706-1002-4f2f-862d-268d24d0ed64#4660)StickyBandithttps://www.blogger.com/profile/08708309679599198684noreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-65861687942158035652015-07-16T14:28:35.145-07:002015-07-16T14:28:35.145-07:00Thanks for this. My JDBC CallableStatement sample ...Thanks for this. My JDBC CallableStatement sample that works with Microsoft SQL Server, MySQL, ASE, SQL Anywhere, and HANA had to be modified considerably to work with Oracle.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-60519564499991507602015-05-10T12:13:22.636-07:002015-05-10T12:13:22.636-07:00Great stuff. Thanks.
Question does the '?...Great stuff. Thanks.<br /><br />Question does the '?' in the call (call jay_proc(?)) somehow represent the "ResultSet"?Anonymoushttps://www.blogger.com/profile/04754131141269088382noreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-17534537999045410532015-05-10T12:12:02.098-07:002015-05-10T12:12:02.098-07:00Great stuff. This saved me a lot of time and frus...Great stuff. This saved me a lot of time and frustration. There aren't many good examples out there.Anonymoushttps://www.blogger.com/profile/04754131141269088382noreply@blogger.comtag:blogger.com,1999:blog-7030997386028100204.post-87085457021406036392014-04-23T23:55:14.562-07:002014-04-23T23:55:14.562-07:00And what about SENDING a ResultSet?
I'll Expl...And what about SENDING a ResultSet?<br /><br />I'll Explain, I must send a list of tickets to one oracle procedure that i can't modify<br /><br />The procedure statement its more or less in this way<br /><br />TYPE T_CURSOR IS REF CURSOR;<br /><br />PROCEDURE Tickets (IDUSER IN VARCHAR2,<br /> TICKETS IN T_CURSOR,<br /> coderror OUT VARCHAR2) IS<br /><br />it's posible to send from java to Oracle?Anonymoushttps://www.blogger.com/profile/17835507936956728793noreply@blogger.com