Re: local variable/column name conflict?

Brenda A Graham wrote
> DECLARE
> code_name varchar2(5) := 'ZZZ%';
> kount integer;
> BEGIN
> SELECT count(*) into kount
> FROM test_table
> WHERE code_name like code_name;
> END;
If this is part of a stored procedure, and the procedure is called my_proc, then use:

    SELECT count(*) into kount
    FROM test_table
    WHERE code_name like my_proc.code_name;

Arjan. Received on Wed May 19 1999 - 16:51:34 CDT