Answer Posted / guest
fun returns values
proc may or may not return values
fun always contain a return statement
proc not.
fun can be used in select queries
proc can not be.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is a user exit program in oracle reports?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
i am writing a query select EmpNo from Emp how can i call in after parameter form
How to create Drill down report?
did u p prepared complex report
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
what is tripstop report?
how do u place it in required folder
What is a canvas in oracle forms?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
What do we mean by record group in oracle forms?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What do you understand by oracle forms?