in procedure how to return a value
Answers were Sorted based on User's Feedback
Answer / santhi
Using OUT parameter we can return any number of values.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / suresh.somayajula
execute <procedure name> ( required val);
| Is This Answer Correct ? | 0 Yes | 0 No |
Who information?s?
what is inbound and outbound interface?
what are the prerequisites for costing transactions?
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
what is the difference between oracle 8i and 9i?
how many groups we can create for query?
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
Can 2 functions have same name & input parameters but differ only by return datatype ?
What is secuirity's in R12 features.
What is template?