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

Answer Posted / hari

it is a stored pl/sql block that is used to perform an
action.And it may or may not return values .

parameters are in,out,in out.

we will take the values from parameters.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2307


What is an Oracle database Partial Backup?

927


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4191


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1007


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

853


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3209


Is there any link between pr form(purchse requisition)and po form(purchase order)

2409


Explain how to close periods in ar. : oracle accounts receivable

1008


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

2151


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1822


1. What is PO rate variance gain and loss?

2541


What is the mandatory setup in cyclecount ?

2445


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1914


What is auto invoicing? Explain : oracle accounts receivable

817


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2231