puzzling thing with oracle...

I am calling a stored procedure from PRO*C that selects data from a table according to three parameters , the index (CHAR(2)) and key (CHAR (36))and option.
WHEN I call the procedure with option '=' The select * from table where index = value1 and key =value2 works when the option is 'LIKE'
select * from table where index = value1 and key like value2% doesn't work although there should be matching data. If I change the stored procedure so that the parameters are VARCHAR2 instead of CHAR() the LIKE statement works while the equal doesn't.

anybody has a clue on what's going on??
thanks,

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Mar 11 2000 - 00:00:00 CST