Dear Friends , I have got a table called city_master from which ia want to select its city_name,city_code,state_name to my JSP program. There are total of 60 records in my city_master table. I want fetch all the 60 records. Can Anyone help me how to write a suitable store procedure code and java code for the same Thanks in advance Abhi here
Hi there, I use Oracle and don't know much about other databases but I've got a feeling that the syntax for stored procedure are slightly different. It would be helpful if you mention the database for there is no point to give you an Oracle solution if you use something else. Cheers Ambrose
Joined: May 10, 2001
Thanks Ambrose, I use Oracle only.I learnt java code how to call a storeprocedure .But how to write a store procedure which fetch me 60 records using cursor etc has to be yet tackled. any idea Pls reply
Is there a need for a StoredProcedure here? Is it part of the specifications that you have to abide by? It seems like a good old PreparedStatement will do for a simple select statement. Stored Procedures are usually used for executing a group of related queries/transactions so that many tasks can be accomplished in one call to the database. Or sometimes shops like to keep the data/data access solely in the hands of the DBA, but this isn't the case if you're writing the Stored Procedure! in short, why not use a PreparedStatement in your java code? Jamie
subject: Store Procedure Codes Badlu In need of Help!!