using parameters in PL/SQL

[Quoted] Hello all,

[Quoted] [Quoted] I have a procedure which accepts two parameters. I would like to use of [Quoted] the parameters, which is varchar2, in a select statement for a cursor. [Quoted] The name of the parameter is ffid. My select statement is:

 CURSOR map_cur IS

    SELECT ARID.INSTALLATION.INSTALLATION_NAME,     ARID.INSTALLATION.FFID,
    REPLACE(ARID.ARID_MAPS.MAP_RANGE_STATUS,'*',NULL) as Status,     ARID.ARID_MAPS.UPDATE_BY,
    TO_CHAR(ARID.ARID_MAPS.UPDATE_DATE,'YYYYMMDD') as UpdateDate,     ARID.ARID_MAPS.INSTALLATION_SCANNED_MAP     FROM ARID.ARID_MAPS, ARID.INSTALLATION     WHERE ARID.ARID_MAPS.INSTALLATION_ID =     ARID.INSTALLATION.INSTALLATION_ID
    AND ARID.INSTALLATION.FFID = ffid ;

I want to use the ffid in the where clause as above. How do I get the quotes around ffid.

Thanks.

Sent via Deja.com
http://www.deja.com/ Received on Sat Jan 20 2001 - 00:57:04 CET