Re: How construct a dynamic sql request in a stored procedure

reqsql needs to be limited to the select, so the statement is open p_curseur for reqsql;

Hth,

Sybrand Bakker, Oracle DBA

"Francky" <fgendre_at_sinfor.fr> wrote in message news:8olvjh$10u0$1_at_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 - 16:10:43 CDT