Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

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.
0
panpanW
Asked:
panpanW
  • 4
  • 3
1 Solution
 
panpanWAuthor Commented:
thanks, but it only tells us how to "Create" procedure, instead of "Invoking" procedure.
0
 
CEHJCommented:
There are related links there too, e.g.

http://javaalmanac.com/egs/java.sql/CallProcedure.html
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
CEHJCommented:
cs.setObject(1, yourListOfTest);
   
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now