stored procedures,lookups

[Former Member]

hi all,

y we use stored procedures,lookups?

regards,

keerthi

[Former Member · Accepted solution]

Keerthi,

Basically if you want to write Business Logic on Database server you use store procedures for that.

Store procedure generally contains number of SQL queries. You can do all validations of input data before updating/inserting data in database table using Stored Procedures.

Normally stored procedures are very fast. Rather than quering database tables multiple times you can write store procedure with all query.

Lookups are basically for checking available data. Rather than storing data at multiple table, you can create your one lookup table and can be used in all tables where same data is required. For eg. if you have country data, you can create lookup table for country and refer this table in all other table wherever you need conutry.

Nilesh

[Former Member]

Hey

>>y we use stored procedures

stored procedures are like small pieces of codes residing on the database server which are executed based upon the incoming message,instead of writin the code again and again in adapters we write the code on the dataabase server itself and invoke it by passing values to it.it justifies the purpose of re-usability

>>lookups

they are basically used to peep into the database,fetch some values and use that in mapping.a simple example of lookup can be looking at the country code from some database table based upon the whole country name.

Thanx

Aamir suhail

[Former Member]

Hi,

im don't know why you use stored procedures ...

but we use it to store data into a oracle database.

regards,

Robin