dcsimg
Data from PL/SQL
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Radha_Lakshminarasimhan
Posted On:   Monday, March 26, 2001 01:37 PM

Hi,

How do i retrieve data, which is in the form of PL/SQL table,
sent to the java program.

Thanx

Radha.

Re: Data from PL/SQL

Posted By:   Ramesh_Jonnadula  
Posted On:   Monday, March 26, 2001 02:24 PM

As far as I know, we can't access PL/SQL table from JDBC as there is no corresponding datatype in Types class. Some vendors do provide extra datatypes that only work in their database drivers, like OracleTypes.CURSOR. As a workaround, You could open a cursor against the PL/SQL table and return that cursor as OracleTypes.CURSOR

Ramesh
About | Sitemap | Contact