how to call a Oracle procedure ?

Posted on 2004-09-17
Medium Priority
Last Modified: 2010-03-31
hi experts,

I need to call an Oracle procedure from a java class, but don't know how to do it? thanks.
Question by:panpanW
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 86

Expert Comment

ID: 12085465

Author Comment

ID: 12085594
thanks, but it only tells us how to "Create" procedure, instead of "Invoking" procedure.
LVL 86

Expert Comment

ID: 12085643
There are related links there too, e.g.

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 12085852
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.
LVL 86

Accepted Solution

CEHJ earned 140 total points
ID: 12086036
cs.setObject(1, yourListOfTest);

Author Comment

ID: 12086091
thanks, but how to update table in the procedure? How to pass the Java class into the Oracle procedure to process it?
LVL 86

Expert Comment

ID: 12086114
>>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

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Suggested Courses
Course of the Month12 days, 9 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question