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 |
Tell me some thing about SQL-LOADER.
Give a overview on Aol
Tell me how to debug the report?
Difference between Bind and Lexical parameters?
How can you achieve loose coupling in soa framework?
What are the validations you don in .CTL file in inbound interface process?
What are documents and test cases u followed.
what is back order in OM
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
In hierarchical structure of a database? we have write query from where we should start?
What are do's and dont's of Interface?