PL/SQL stored procedure parameters?
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 secuirity's in R12 features.
what are version control tools used in oracle apps?
In what situation u create the BPA.
what is inbound and outbound interface?
What do you understand by soa and what are the benefits of using this architecture?
After deploying like forms,reports into server how we connect this forms,reports to web?
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
how will u do documentation
How will u register concurrent request ?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
tell me the scenarios of between pages in reports
what do you mean by value sets