how to call a Oracle procedure ?

hi experts,

I need to call an Oracle procedure from a java class, but don't know how to do it? thanks.
panpanWAsked:
Who is Participating?
 
CEHJConnect With a Mentor Commented:
cs.setObject(1, yourListOfTest);
   
0
 
panpanWAuthor Commented:
thanks, but it only tells us how to "Create" procedure, instead of "Invoking" procedure.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
CEHJCommented:
There are related links there too, e.g.

http://javaalmanac.com/egs/java.sql/CallProcedure.html
0
 
panpanWAuthor Commented:
thanks, but I need to pass an ArrayList of Class "test" into the procedure, and I don't know how to do it from the example.

Class test
{
 String name,
 int cust_id
}

**************
in the procedure, I need to check if the record has existed, if YES, then update the record, if NO, then insert the record.
0
 
panpanWAuthor Commented:
thanks, but how to update table in the procedure? How to pass the Java class into the Oracle procedure to process it?
0
 
CEHJCommented:
>>thanks, but how to update table in the procedure?

Well that's really an Oracle question, not a Java question, is it not?

>>How to pass the Java class into the Oracle procedure to process it?

My last code example shows that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.