Using bind variables with dynamic SELECT INTO clause in PL/SQL

by

In my opinion, a dynamic PL/SQL block is somewhat obscure. While is very flexible, is also hard to tune, hard to debug and hard to figure out what’s up.
My vote goes to your first option,

EXECUTE IMMEDIATE v_query_str INTO v_num_of_employees USING p_job;

Both uses bind variables, but first, for me, is more redeable and tuneable than @jonearles option.

More Related Contents:

  1. REGEX to select nth value from a list, allowing for nulls
  2. PLS-00428: an INTO clause is expected in this SELECT statement
  3. Sleep function in ORACLE
  4. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  5. Subtracting Dates in Oracle – Number or Interval Datatype?
  6. How to call Oracle MD5 hash function?
  7. Receive an unexpected symbol error in my PLSQL query [closed]
  8. Splitting string into multiple rows in Oracle
  9. Search All Fields In All Tables For A Specific Value (Oracle)
  10. What is the string concatenation operator in Oracle?
  11. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  12. How can I select from list of values in Oracle
  13. passing table and column name dynamically using bind variables
  14. How to get the last row of an Oracle table
  15. Is there any way to flush output from PL/SQL in Oracle?
  16. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  17. INSERT SELECT statement in Oracle 11G
  18. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  19. Nth max salary in Oracle
  20. PLSQL Insert into with subquery and returning clause
  21. What does the colon sign “:” do in a SQL query?
  22. Autoincrement in oracle to already created table
  23. Oracle 11g – Check constraint with RegEx
  24. Advice Using Pivot Table in Oracle
  25. How to use a dynamic parameter in a IN clause of a JPA named query?
  26. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  27. The network adapter could not establish the connection – Oracle 11g
  28. How to use Alias in Where clause? [duplicate]
  29. Oracle RAC and sequences
  30. ORACLE After update trigger: solving ORA-04091 mutating table error

Leave a Comment