• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Mapping java collections as In parameters to Varrays

 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Guys,

I have a java programme passing input parameters to a procedure. These input parameters are of types string, long, and few collections. These collections are user defined objects. And the procedure returns 2 output parameters of type ref cursors.

And my procedure contains few remote procedures and I'm passing few input parameters(which are not collections) into the main remote procedure and as i said it returns errorset and resultset cursors. One cursor contains errorcode and error messages and the other cursor contains unique identifier.

Here I got 3 problems.

1. If the data what I'm passing inside the main procedure is correct, Unique identifier is available in one of the cursors and I need to retreive that Id and use it in some other remote procedures. I could able to insert the data through the remote procedure call if I dont try to fetch Id from a cursor. I couldn't able to fetch the unique identifier from the cursor.

The error when I'm trying to loop the cursor and fetch the Id is,
ORA-02055: distributed update operation failed; rollback required ORA-24338: statement handle not executed ORA-06512: at line 51

and when I click on the error code, I got the below message.

Cause

A failure during a distributed update operation may not have rolled back all effects of the operation. Since some sites may be

inconsistent with others, the transaction must roll back to a savepoint or roll back entirely.


Action

Roll back to a savepoint or roll back the entire transaction and resubmit the rolled-back statements.

I didnt understand what is the error message imply.

2. Inside my procedure I'm passing few input parameters which are of type varray. I don't know how to pass java collection as IN parameters which map to varrays. I'm not quiet sure whether I can pass java collections to Varrays.

3. One of the field in one remote procedure is of type clob. Remote procedure call is not allowing me to pass data in to that clob field.

I'm not good at remote procedure calls and in calling stored procedures from java.

Any pointers for my above problems?

Thank You,
Rasi.
[ April 08, 2005: Message edited by: Bear Bibeault ]
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Rasi,
The following Web page may be of help:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html

Good Luck,
Avi.
 
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Avi,

Thanks for your help..

The link which you have given is good.. But it didn't help me much.

I'm still investigating on the net for my problems. Still no clues. I require a solution to my problem ASAP to continue my work. Any small help will be appreciated.

Thanks in Advance,
Rasi.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic