Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Package +JDBC

 
Sanjay Deshpande
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic