Solved

how to call a Oracle procedure ?

Posted on 2004-09-17
9
196 Views
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.
0
Comment
Question by:panpanW
  • 4
  • 3
9 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 12085465
0
 

Author Comment

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

Expert Comment

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

http://javaalmanac.com/egs/java.sql/CallProcedure.html
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:panpanW
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.
0
 
LVL 86

Accepted Solution

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

Author Comment

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

Expert Comment

by:CEHJ
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
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

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…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

757 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now