What is store procedure?and how do u take the values from
database and run in scripts?

Answer Posted / dsr

Store Procedure is a procedure. it may or maynot return values.
Ex: create procedure procedure_name

begin

start

end.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to write customizations in po

1201


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

716


What is the difference between oracle media recovery and crash recovery?

680


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

668


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1618






Differentiate between transaction type and transaction source? : oracle accounts receivable

681


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2364


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1650


HOW TO SPOT AHIERARCHY?

1851


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1774


How would you determine who has added a row to a table?

1796


can we use lexical perameter in oracle plsql if yes how

1826


What do you mean by hz_ in customer tables? : oracle accounts receivable

644


where the dff data will be stored

1803


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1916