“rowtype” here is an Oracle PL/SQL-specific type, I don’t think it would be supported by JDBC. A quick search of the oracle forums (google “jdbc rowtype site:oracle.com”) suggests the same. You’re probably better off returning a cursor, or just execute the SQL from JDBC directly.
Matthew Quiros
Am I right to think that though using a cursor will preserve the goal of storing all logic in the Oracle side, directly executing the SQL from JDBC will perform faster?
Roy Tang
It is correct that executing the SQL directly in JDBC is faster
If you enjoyed my content for some reason, I'd love to hear from you! Here are some options:
- You can buy me a coffee!
- You can write a reply on your own site and submit the URL as a webmention via the form below.
- Or you can just contact me!