Oracle 00904 & 06512 errors

Hi,

I'm getting these errors when i execute a simple stored proc.

PROCEDURE getOpStudKey(
p_refer_op IN VARCHAR2,

p_curs OUT t_curs

)

IS

requete VARCHAR2(1000);

BEGIN requete := 'SELECT ME.refer AS refer, ME.libelle AS libelle

FROM MC_ETUDES ME, OP_MC_ETUDES OME WHERE ME.refer = OME.refer_mc_etudes

AND OME.refer_op = '||p_refer_op||' ORDER BY libelle ASC';

OPEN p_curs FOR requete;

END getOpStudKey;

If p_refer_op is equal to a string-number (ex : 2004001), it's ok

When it contains a char (ex : E2004001), I get the error.

What can it be due to ? Any explanations concerning these errors ?

Thanks,

Laurent. Received on Wed Apr 28 2004 - 08:28:19 CDT