>HI, I try to execute this:
>
>EXECUTE IMMEDIATE 'SELECT COUNT(*) INTO v_nCountRes FROM '||v_cTable
>
>Oracle gives me an exception : -905 missing keyword
>
>What is wrong ?
>
>Thank you for your help,
>Christian
The syntax from one of my Oracle ref books is:
exec sql execute immediate "select count(*) into v_CountRes from " || v_CTable;
Mark McCasland
Midlothian, TX USA