Re: Forms45 Question about CURSOR and DECODE

From: Paul Donovan <pdonovan_at_clara.net>
Date: Sun, 15 Nov 1998 01:43:42 -0000
Message-ID: <72lblg$nj9$1@eros.clara.net>

Hi,

Buergi Josef wrote in message
<01be0e56$84cf3160$4b7d4f8b_at_rac17217.hasler.ascom.ch>...

> CURSOR par_cur (kkey_p NUMBER, sorting_p CHAR) IS

I think it is this CHAR that is the problem. Try using VARCHAR2 and see if that helps. I think that CHARs get padded out with spaces so if you pass a varchar2(6) then you will get your value padded and it won't compare in the decode.

Let me know.

Regards,

Paul

PS. You said it didn't work - but you didn't say what the result was !?!? Received on Sat Nov 14 1998 - 19:43:42 CST