How construct a dynamic sql request in a stored procedure

From: Francky <fgendre_at_sinfor.fr>
Date: Thu, 31 Aug 2000 18:02:48 +0200
Message-ID: <8olvjh$10u0$1@news6.isdnet.net>

Hi,

I have a stored procedure with some parameters This arguments are used to construct a dynamic sql request My syntax is :

PROCEDURE sp_list(p_cursor IN OUT ref_cursor, noliste IN NUMBER) IS
reqsql varchar2(1000);
BEGIN
reqsql := 'OPEN p_curseur FOR '

     || 'SELECT '


        || 'LISTE.NO_LISTE, '

        || 'INSCRIPTION.DATE_CREATION '

     || 'FROM '


        || 'LISTE LISTE, '

        || 'INSCRIPTION INSCRIPTION '

     || 'WHERE '


        || 'LISTE.NO_LISTE ='||noliste||' AND '

        || 'LISTE.NO_LISTE = INSCRIPTION.NO_LISTE';

execute immediate reqsql;
END; This syntax isn't correct.
Have you an idea on my problem ?
Thank's a lot Received on Thu Aug 31 2000 - 11:02:48 CDT