aspose file tools*
The moose likes JDBC and the fly likes examples for stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "examples for stored procedures" Watch "examples for stored procedures" New topic
Author

examples for stored procedures

clyde melly
Ranch Hand

Joined: Sep 04, 2003
Posts: 152
Any examples on using OUT and IN OUT parameter for stored procedures.Using
Java with oracle8i.Thanx
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Hi Clyde,
The following Web page has an example. Although it talks about Oracle 9i, I'm fairly sure that it will work for Oracle 8i as well.
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/basic/plsqlSample/Readme.html
There are also examples in the Oracle documentation, which can be accesses from
http://tahiti.oracle.com
And you can also try searching the "Ask Tom" Web site
http://asktom.oracle.com
Good Luck,
Avi.
clyde melly
Ranch Hand

Joined: Sep 04, 2003
Posts: 152
Thanx.Worked on stored procedures yesterday,but having problem with functions when using in java.The function gets created,but when called in the java program,the program gives an error on runtime
Sainudheen Mydeen
Ranch Hand

Joined: Aug 18, 2003
Posts: 218
Hi
You have problem in calling an Oracle function from java? Can you explain bit more?
-Sainudheen
clyde melly
Ranch Hand

Joined: Sep 04, 2003
Posts: 152
I have created a function in oracle which basically updates or does an insert with retrning a value.Now when i call it in java,i dont get the return value.Any examples on java calling the function along with the created function will be of immense help.thanx
Sainudheen Mydeen
Ranch Hand

Joined: Aug 18, 2003
Posts: 218
Hi
How do you call your oracle function from java. Can you post the code?
-Sainudheen
clyde melly
Ranch Hand

Joined: Sep 04, 2003
Posts: 152
Now the code works up.Just had to read thru some tutorials and help and everything works up fine.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: examples for stored procedures
 
Similar Threads
Problem in build jar files
CloudScape Stored Procedures
Tomcat--where are the servlets stored?
Display ArrayList of objects without jstl?
getting ResultSet from Java Stored Procedure