Oracle Cursor and JDBC ODBC

Posted by BeginnerAmongBeginners on Stack Overflow See other posts from Stack Overflow or by BeginnerAmongBeginners
Published on 2010-06-16T17:19:49Z Indexed on 2010/06/16 17:22 UTC
Read the original article Hit count: 213

Filed under:

Oracle

|

jdbc

|

odbc

|

sys-refcursor

I have some procedures to execute in the database that has an OUT REFCURSOR parameter.

When I am connecting with the JDBC thin client, everything works fine. However, if I were to change the connection string to refer to the ODBC data source pointing to the same database, those procedures will fail. The procedures that do not use an OUT REFCURSOR will still work fine though.

Is this situation the result of an error on my part or expected?

© Stack Overflow or respective owner

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Related posts about jdbc

JDBC: What is the correct JDBC URL to connect to a RAC database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We were connecting to Oracle from our code with a simple (custom) JDBC connector class. This class reads the connection properties from a resource file and tries to make a connection to Oracle (thin connection). However, recently the database have moved to a RAC and now the application is unable… >>> More
JDBC Licensing - Packaging jdbc in jar

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there. I'm packaging my open-source non-commercial java application in a .jar and I'd like to package the JDBC mysql-connector with it as it is a dependency. The issue that I am having is that I'm uncertain whether or not this is frowned upon or even illegal due to the JDBC license. I've also… >>> More
jdbc:jtds:sqlserver driver problem

as seen on Stack Overflow - Search for 'Stack Overflow'
sonar.jdbc.url: jdbc:jtds:sqlserver://127.0.0.1/SQL2008:1433/Sonar sonar.jdbc.driverClassName: net.sourceforge.jtds.jdbc.Driver sonar.jdbc.validationQuery: select 1 sonar.jdbc.username: Sonar sonar.jdbc.password: … >>> More
Memory Leak Issue in Weblogic, SUN, Apache and Oracle classes Options

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please find below the description of memory leaks issues. Statistics show major growth in the perm area (static classes). Flows were ran for 8 hours , Heap dump was taken after 2 hours and at the end. A growth in Perm area was identified Statistics show from our last run 240MB growth… >>> More
?????????????????????????|WebLogic Channel|??????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Java EE????????·????????????????/??????????????????????·?????????????????????????WebLogic Server?????????????WebLogic Server???????????????????·??????????????????????????????????????????????????????????(???)???????WebLogic Server???????　????WebLogic Server 11g(10.3.5)??????????????????????… >>> More