Hi All,
I have a stored procedure that will be executed against various departments which passes in a parameter (dept_id). It is straight forward to run it through sqlDeveloper because the bind causes a dialog box to appear for assigning a value to the parameter.
e.g.
In sqlDeveloper I can just run:
execute update_department_rows(p_department => :dept);
when running the above in sql + , I am getting the Bind variable "DEPT" not declared.
As this will be run outside of sqlDeveloper on a department by department basis, I don't really want to be changing the sql file to "execute update_department_rows(p_department => 1);" and so on for each department.
Thanks in advance
Chris