|
|
|
|
|
|
|
|
Re: can we call any procedure from select statement [message #272625 is a reply to message #272623] |
Fri, 05 October 2007 14:09   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Both are valuable ways of writing.
I agree, this "create or replace function f_get_emp_name (emp_id_p in number, emp_age_p out number) return varchar2;" is awful, if you want to return name and age the use "create or replace function f_get_emp_name (emp_id_p in number) return emp_record;" where emp_record contains both age and name.
Using exceptions is great and I use them often. But some sites prefer return code and error message to exception. Each site has its code standard. (Often in this case I internally use exceptions and wrap this internal package to external one that translates exceptions to error messages.)
I programmed for 30 years in many and many languages of all types, procedural, object, internal, and other weird types of programming (logic, math, list... even binary) that does not look of anything else.
Regards
Michel
[Updated on: Sat, 06 October 2007 14:53] Report message to a moderator
|
|
|
|