Re: Oracle 00904 & 06512 errors

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 28 Apr 2004 15:52:19 +0200
Message-ID: <c6od58$e5s2u$1@ID-93924.news.uni-berlin.de>

Hi, Laurent !

If the in-variable is VARCHAR, then treat it that way; you wrote SQL for NUMBER:
> AND OME.refer_op = '||p_refer_op||' ORDER BY libelle ASC';

This makes " ... AND OME.refer_op = E20767623 ... " - obviously wrong.

For a VARCHAR2, write

AND OME.refer_op = '''||p_refer_op||'''

instead. This makes " ... AND OME.refer_op = 'E20767623' ..."

hth, Jan Received on Wed Apr 28 2004 - 08:52:19 CDT