examples for stored procedures

[clyde melly]

Any examples on using OUT and IN OUT parameter for stored procedures.Using
Java with oracle8i.Thanx

[Avi Abrami]

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]

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]

Hi
You have problem in calling an Oracle function from java? Can you explain bit more?
-Sainudheen

[clyde melly]

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]

Hi
How do you call your oracle function from java. Can you post the code?
-Sainudheen

[clyde melly]

Now the code works up.Just had to read thru some tutorials and help and everything works up fine.