plsql & decode

Hi. I have declared the following cursor in a plsql procedure:

Procedure tbl_list (pcode IN VARCHAR2) is

CURSOR get_info_C is
SELECT
code, desc
FROM codetable
WHERE 0=0
ORDER by DECODE (pcode, 'code', code, 'desc', desc, swvstyp_code);

I would like to also pass either desc or asc from a href. Seems like I can't do another decode. Any idea how to get around this?

many thanks
cheers,
tony
902.494.1021 w
902.461.4550 h Received on Tue Jun 04 2002 - 10:24:02 CDT