Interested to Buy Any Domain ? << Click Here >> for more details...
PL/SQL stored procedure parameters?
- 7 Answers
- 24295 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 |
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
is UOM maintained at master level or organization level or both?
in GL module specifing org_id or not?
how to set org context?
can we use look up type instead of a pofile option?or valueset?is it possible how?
how many groups we can create for query?
After deploying like forms,reports into server how we connect this forms,reports to web?
what is global tempory table?
what are the functions you are used in utl_file at the time of transferring the data?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is the difference between oracle 8i and 9i?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
Oracle Apps Technical 
