in procedure how to return a value

Answer Posted / sneha

declare the procedure with out variable, assign the value
to the out variable inside the procedure. out variable
should not be declared again inside the procedure.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the Standard Reports and Forms in HRMS?

1962


What is the concept of soa governance?

984


What is oracle soa suite and what are its different components?

885


Tell me how to debug the report?

838


Can u give the Documentation of Custom.pll in oracle apps

3215


How can we import the data into a database using sql * loader?

880


What is sca and how is it useful?

833


what is the difference between request group and request security in oracle apps?

5427


where to define interorganization transaction charges and what are the different options?

2143


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1792


What is a value set? List its various types.

843


What are file in oracle.

1998


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1835


how can develope the po variance and po summary report? with tables mandatory columns and query please?

2148


How can a process be deployed in soa?

888