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

Does pdo prevent sql injection?

990

---

Can a key be both primary and foreign?

1055

---

Is left join faster than join?

1096

---

What is schema in sql?

999

---

Define commit, rollback and savepoint?

1081

---

What are the disadvantages of file system?

1360

---

What is difference between cursor and trigger?

1129

---

How do I start sql from command line?

1081

---

What are the different dcl commands in sql?

1231

---

What is pivot table in sql?

1171

---

what is a stored procedure? : Sql dba

1192

---

Why do we create views in sql?

1218

---

What is a mutating table and a constraining table?

1178

---

What is rtm in testing?

1175

---

Define union, minus, union all, intersect ?

1064

---