equal names of: parameter of procedure - columns of table

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 Received on Mon May 23 2005 - 04:43:13 CDT