PL/SQL stored procedure parameters?
- 7 Answers
- 20936 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / niranjan
Procedure/function (ERRBUF OUT
RETCODE OUT
???????.)
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 ? | 16 Yes | 2 No |
Answer / sreenivasula reddy.bhumireddy
errbuf----> it is used for displaing userdefined message
or system defined message
retcode----> to dispaly the status of the program whether
it is 0--normal
1-->warning
2-->error
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / manju
Hi All,
we can use the PL/SQL stored procedure using the parameters
(in,out,in-out)and
suppose our stored procedure register into the Oracle apps
then we will using the 2 mandatory parameters those are
(errbuf ,retcode)
Errbut : error buffer will be used to get back to the error
message.
Retcode: give the error code & compilation status.
0- successful execution .
1- success with warning.
2- Error.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / ravi soma
Stored Procedure parameters are mainly 3 Types
They are IN
OUT
INOUT.
If we register the procedure in Oracle Apps as concurrent
Program then we have to pass above parameters and
additionally 2 more out parameters.
They Are-errbuf out varcher2
-retcode out Number or Varchar2
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / badari
Addition to above answer
Parameters will be classified as follow:
IN
OUT
IN OUT
| Is This Answer Correct ? | 7 Yes | 11 No |
Answer / sreenivasula reddy.bhumireddy
Diifferent select statements can be associated in a single
cursorname based on one or more tables
syn: type <typename> is refcursor --weak refcurrsor
type <typename> is refcursor with return type ---strong
| Is This Answer Correct ? | 1 Yes | 7 No |
how can u link a org-id with a responsibility in reports?
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
what is pick selection list generation report.
How to move the one file from one instance to another instance? And your scripts also?
what is the standard program for blanket po to process data from interface table to bace table
which parameters passed in report in oracle developer how to pass
what is the data type of lexical parameter?
What are Mandatory triggers to write in the block, which is created on view?
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
why r u move in the cus_top only why not move another top
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
Oracle Apps Technical 
