%rowtype mapping in java

[Puneet Jain]

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]

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.

[Jeanne Boyarsky]

"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

[Puneet Jain]

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]

"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

[Jeanne Boyarsky]

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.