Which type of binding does PL/SQL use?

  • Interview Candidate
  • 10
  • 16580

Editorial / Best Answer

g_sidhu  

  • Feb 1st, 2008

Before a PL/SQL program can be executed, it must be compiled. The PL/SQL compiler resolves references to Oracle objects by looking up their definitions in the data dictionary. Then, the compiler assigns storage addresses to program variables that will hold Oracle data so that Oracle can look up the addresses at run time. This process is called binding.


How a database language implements binding affects runtime efficiency and flexibility. Binding at compile time, called static or early binding, increases efficiency because the definitions of database objects are looked up then, not at run time. On the other hand, binding at run time, called dynamic or late binding, increases flexibility because the definitions of database objects can remain unknown until then.

Showing Answers 1 - 10 of 10 Answers

g_sidhu

  • Jan 31st, 2008
 

Before a PL/SQL program can be executed, it must be compiled. The PL/SQL compiler resolves references to Oracle objects by looking up their definitions in the data dictionary. Then, the compiler assigns storage addresses to program variables that will hold Oracle data so that Oracle can look up the addresses at run time. This process is called binding.


How a database language implements binding affects runtime efficiency and flexibility. Binding at compile time, called static or early binding, increases efficiency because the definitions of database objects are looked up then, not at run time. On the other hand, binding at run time, called dynamic or late binding, increases flexibility because the definitions of database objects can remain unknown until then.

gwilson5

  • Sep 4th, 2010
 

When you bind, you associate values from your program(host variables) with placeholders inside your SQL statement.  With static SQL, the PL/SQL, engine itself performs these binds.  With dynamic SQL, you must explicity request a binding of variable values.

  Was this answer useful?  Yes

Art11

  • Sep 24th, 2011
 

This is the best answer I found:

Early binding is checking for existence of objects referred in the program unit during the compilation phase. Late binding will not check the existence of objects till the runtime

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions