Hallo,

is there an way, to make a difference between the parameter of a
procedure and the column name of a table if the name is equal?

in firebird it is no problem, because in a sql statement I have to use
colon in from of a variable for example:

select * from machines m where m.age > :age

when I write in Oracle
select * from machines m where m.age > age

then this is not doing what I want.
I would be lucky if I don't need to rename my variable names and there
is another way to get what I want.

Thank you,
Werner Hofmann

Werner Hofmann wrote:
You can do this:

procedure my proc (age in number) is
begin
select * from machines m where m.age > myproc.age;
....

On Mon, 23 May 2005 11:43:13 +0200, Werner Hofmann
<superomega (AT) t-online (DOT) de> wrote:

There is not. Obviously, the error starts with assuming there is.




--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
Except that there is. Here's a working example:

SQL> create or replace function get_name (empno in number)
2 return varchar2
3 is
4 ename emp.ename%type;
5 begin
6 select emp.ename into get_name.ename
7 from emp
8 where emp.empno = get_name.empno;
9 return get_name.ename;
10 end;
11 /

Function created.

SQL> select get_name(7900) from dual;

GET_NAME(7900)
--------------------------------------------------------------------------------
JAMES

**NOT** that I am advocating doing this if it is avoidable. The scope
for error is much greater than if a different naming convention is used
for parameters.

On 23 May 2005 07:07:17 -0700, andrewst (AT) onetel (DOT) com wrote:

In the OP's case, it would still mean, he would need to change
everything, wouldn't he?
So what is the difference in that case between doing this properly,
and implementing this hack?


--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
1) I already said I wouldn't advocate this approach if it could be
avoided.

2) There is nothing "improper" or "hack"-like about using a feature
simply because you apparently didn't know about it.

3) The difference would be if he already has published package specs
that use parameters with such names, and referenced them in code. This
approach will allow him to change only the internals of the package
body.

andrewst (AT) onetel (DOT) com wrote:
Thank you it's working