CREATE OR REPLACE Procedure/function <Procedure/function

PL/SQL stored procedure parameters?

Question Posted / tathagat

7 Answers
24010 Views
I also Faced
E-Mail Answers

Answer Posted / tathagat

CREATE OR REPLACE Procedure/function
<Procedure/function_NAME) (ERRBUF OUT NUMBER,RETCODE OUT
VARCHAR2 number ,PARAMETER1 IN <DATATYPE>,..,) AS
BRGIN
........;
........;
END;

ERRBUF :- Used to write the error message to log
or request file.
RETCODE :- Populate log request file with program
submission details info.

Is This Answer Correct ?

4 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain oracle apps architecture.

1241

How do you register report in oracle apps?

1092

Can u give the Documentation of Custom.pll in oracle apps

3467

In hierarchical structure of a database? we have write query from where we should start?

2238

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2209

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2629

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

2256

Can you explain the difference between architecture followed in 10g & 11g?

1060

how to print multi lay outs,muti currency,muti language in xml publisher

12280

What are file in oracle.

2227

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2614

Is soa a part of oracle fusion middleware?

1085

what is the differences between internal requisition and internal sales order?

2652

where to define interorganization transaction charges and what are the different options?

2416

How can you achieve loose coupling in soa framework?

1214