pl/sql ref cursor question

0 pts.
Tags:
Database
DB2
DB2 Universal Database
Oracle
SQL
Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an oracle ref cursor 3. Pass the ref cursor into a pl/sql stored procedure Any thoughts on how to do this would be greatly appreciated. Thanks.
ASKED: August 1, 2006  6:11 PM
UPDATED: August 2, 2006  12:22 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

To give a vague answer to a vague question, probably. It depends, to a large extent, on what type of resultset you’re starting with.

Check these out for more details.

http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=7&rl=1

http://www.csee.umbc.edu/help/oracle8/java.815/a64685/oraext3.htm

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ajhaveri
    Hi - thanks for the answer. To be a little more clear on the problem i've created the following Java pseudocode String sqlStmtRead = "SELECT COUNT(*) FROM TABLE"; //DBRes is a class that handles database functions ResultSet rs = DBres.executeSelectQuery(conn, sqlStmtRead); //Cast the resultset into an OracleResultSet OracleResultSet ors = (OracleResultSet)rs; // THE QUESTION // Can i obtain a reference to the OracleResultSet ors and // pass it as a parameter (cursor or record type) to a // plsql procedure for processing. And if so how would I do // this. Thanks!
    0 pointsBadges:
    report
  • Ajhaveri
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/plsql-ref-cursor-question/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following