Java Answers Forum - is there an object in java compatible with a pl/sql record type

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
is there an object in java compatible with a pl/sql record type

1 reply on 1 page. Most recent reply: Jan 21, 2003 12:47 AM by srinivas

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 1 reply on 1 page

David

Posts: 1
Nickname: dtwining
Registered: Jan, 2003

is there an object in java compatible with a pl/sql record type

Posted: Jan 20, 2003 11:13 AM

I am trying to find out if Java has a type that is the same as a pl/sql record type that can be used in oracle. What we want to do is call a stored procedure in Java to an Oracle database with an in parameter of pl/sql record type. From this record we will extract individual values and call other APIs to put this information into the Oracle database tables. What I am not sure of is can this record be developed in Java and then used in the stored procedure call to the database? And if so how? Hope this is clear enough. Any help would be greatly appreciated.

srinivas

Posts: 6
Nickname: srinivas
Registered: Nov, 2002

Re: is there an object in java compatible with a pl/sql record type

Posted: Jan 21, 2003 12:47 AM

HI

This can be possible using SQLJ,
Oracle is supporting a lot of API, which can be used in Java in to Oracle and vise versa

even we can call java methods as an Oracle functions and can be called in oracle in PL/SQL.

I think so this can help u !

Regards
Srini Vallepu

Flat View: This topic has 1 reply on 1 page

Previous Topic

Next Topic


	Web Artima.com