Re: Funciton & VARCHAR2 problem

ver 8.1.7, Win2k.

The column "code" in table dd is defined as char(4).

How do I define variable p_code? The "FUNCTION dCount (p_code IN VARCHAR2)" declaration gives no results at all, i.e. count is 0. If I try to declare it as "CHAR(4)" I get compilation error.

>Version? OS? Which errors?
>
>With 8.0.5.1.0 on Solaris 2.6 it's no problem:
>
>KNUT_at_TST.TALMAN.DE> create table dd (code varchar2(10));
>
>Table created.
>
>KNUT_at_TST.TALMAN.DE> insert into dd values ('AA');
>
>1 row created.
>
>KNUT_at_TST.TALMAN.DE> commit;
>
>Commit complete.
>
>KNUT_at_TST.TALMAN.DE> create or replace FUNCTION dCount (p_code IN VARCHAR2)
>2 RETURN NUMBER IS
>3 result NUMBER;
>4 BEGIN
>5 select count(*) INTO result from dd a
>6 where a.code=p_code;
>7 RETURN result;
>8 END;
>9 /
>
>Function created.
>
>KNUT_at_TST.TALMAN.DE> select dCount('AA') from dual;
>
>DCOUNT('AA')
>------------
> 1
Received on Wed Apr 10 2002 - 12:49:49 CDT