aspose file tools*
The moose likes JDBC and the fly likes Oracle Package +JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Package +JDBC" Watch "Oracle Package +JDBC" New topic
Author

Oracle Package +JDBC

Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
I have a table called EMP.
I want to get all rows of the tble in a SP and the display using JDBC
how can i do it?
How can i write a package for this and then execute it in java?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Hold on there partner!!! That's a lot of stuff for a forum question. How about you read a java book, do some tutorials, or just plain try first!
Let's start with how do I program in java--> start here
how do I create a GUI for displaying my records--> User Interfaces that SWING - pay attention to the JTable section
how do I access a database from java -->JDBC trail - pay attention to the CallableStatement section
How can i write a package for this and then execute it in java --> This might help
Feel free to ask anymore questions if you encounter any problems ( preferrably after you attempt to do it yourself! )
Jamie
Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
Well what i m looking for is ,
i have a package that returns
Select * from a table.
This is not possible in a Sp till we use package.
So what i want to know is how to rite this package and call THIS PACKAGE in jdbc.
Plz lemme know this one.
 
 
subject: Oracle Package +JDBC