how to call a Oracle procedure ?

Posted on 2004-09-17
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
  • 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.
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.


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 35 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
custom annotations 9 42
Opening PDF on button click and fill new document 2 47
throw exception 21 58
American Express @Work site and Java 4 30
For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

828 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