can u call procedure or function is sq l query in reports

Answer Posted / swarna

We can call the Function in the sql query in reports but
not the Procedure.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by lov and how can it be used?

557


i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2447


Is it possible to execute a dynamic sql from forms?

568


What do you understand by oracle forms?

560


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1528






If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

1790


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

784


What is the difference between BPA AND Contract What are documents and test cases u followed

1922


where do u put the report file

1620


from where do u receive the information to develop report

1508


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

820


What is an SQL FORMS ?

2281


What do you understand by lov?

538


did u received a single file or multiple files

1587


What is a canvas in oracle forms?

560