File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes %rowtype mapping in java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "%rowtype mapping in java" Watch "%rowtype mapping in java" New topic
Author

%rowtype mapping in java

Puneet Jain
Greenhorn

Joined: Jun 17, 2004
Posts: 5
Hi

I have a stored procedure having %rowtype as in parameter.
how do i call this procedure from the jdbc callable statement

thanks
Puneet
tommy k. lee
Greenhorn

Joined: Jun 16, 2004
Posts: 20
CallableStatement objects are created with the Connection method prepareCall. The example below creates an instance of CallableStatement that contains a call to the stored procedure getTestData, which has two arguments and no result parameter:

CallableStatement cstmt = con.prepareCall(
"{call getTestData(?, ?)}");

Whether the ? placeholders are IN, OUT, or INOUT parameters depends on the stored procedure getTestData.


SCJP,SCJD SCEA, SCWCD, SCBCD<br />OCP DBA 8i / 9i<br />CISSP, PMP, PHR<br />CCNA, CCDA <br /><a href="http://www.certgear.com" target="_blank" rel="nofollow">http://www.certgear.com</a>
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30512
    
150

"teenup teenup"

We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks,
Jeanne
JDBC Forum Bartender


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Puneet Jain
Greenhorn

Joined: Jun 17, 2004
Posts: 5
Hi
thanks but u did not read my query carefully



I have a stored procedure having %rowtype as in parameter.
how do i call this procedure from the jdbc callable statement
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61199
    
  66

"teenup", Jeanne's request for you to change your display name was not a suggestion. The change is required. Be advised that accounts with invalid display names are subject to deletion.

bear
Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30512
    
150

Puneet,
Thanks for changing the display name. It's much better now.

I found a similar question posted in this forum a couple years ago. It seems to answer the question.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: %rowtype mapping in java