This content has been marked as final. Show 2 replies
That really is a question for the SQL and PL/SQL forum:
But try using another name for the job_id parameter. The query
select ... from jobs where job_id=job_id;returns all rows in the table since job_id = job_id is true for all rows.