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

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2289


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

927


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

2173


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1887


What view would you use to determine free space in a tablespace?

2038


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3626


What is autocashrule set? : oracle accounts receivable

1036


What is auto invoicing? : oracle accounts receivable

882


1. What is PO rate variance gain and loss?

2561


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16985


what are the API of GL,PO,AP

2026


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1889


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

871


Explain the process of recievables in oracle financials. : oracle accounts receivable

917


how to replace not in with not exist?

3421