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 |
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
mention the interface tables for item open interface and open transaction interface and also their respective production tables.
explain registration steps of a concurrent program.
What repots or concurrent program run to transfer data from Inventory to GL.
can we get profile values in report without using user exists is it possible how?
while running a interface if we get 100 records as erors. how to debug it.
link between po and ap modules
Where we can write a PL/SQL code in report triggers?
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
what is pick selection list generation report.
for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake
What is ment by Global Templates in Oracle.