Answer Posted / abhishekjaiswal

DECLARE
  FUNCTION my_func RETURN NUMBER IS
  BEGIN
    RETURN 2;
  END my_func;




  PROCEDURE my_proc IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE(my_func + 1);
  END my_proc;




BEGIN  -- main
  my_proc;
END;    -- main
As shown above, with the function declared first you can call the function from the procedure. However, if you try something like the following (function declared before procedure, and function calls procedure):




DECLARE
  FUNCTION my_func RETURN NUMBER IS
  BEGIN
    my_proc;
    RETURN 2;
  END my_func;




  PROCEDURE my_proc IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE('22');
  END my_proc;




BEGIN  -- main
  DBMS_OUTPUT.PUT_LINE(my_func);
END;    -- main
the compile will fail, because my_func cannot 'see' my_proc. To make it work you need to put in a 'prototype' declaration of my_proc, as follows:




DECLARE
  PROCEDURE my_proc;




  FUNCTION my_func RETURN NUMBER IS
  BEGIN
    my_proc;
    RETURN 2;
  END my_func;




  PROCEDURE my_proc IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE('22');
  END my_proc;




BEGIN  -- main
  DBMS_OUTPUT.PUT_LINE(my_func);
END;    -- main

when MSQL8.0 is in market

2064

---

How to find 3rd highest salary of an employee from the employee table in sql?

1061

---

i have some prob lem to tell me about my self in interview first round ...

2151

---

What is sql*plus?

1058

---

What is sql profiler in oracle?

1070

---

what are aggregate and scalar functions? : Sql dba

1041

---

Explain 3 basic parts of a trigger.

1299

---

How do I count records in sql?

980

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1199

---

Why truncate is used in sql?

984

---

Which sql statement is used to return only different values?

986

---

how can we destroy the cookie? : Sql dba

995

---

What is pl/sql table? Why it is used?

1024

---

what is the difference between a having clause and a where clause? : Sql dba

1062

---

How to know the last executed procedure?

1071

---