Re: PIPELINE FUNCTION varchar parameters no rows returned

On 21 Mar 2006 19:00:58 -0800, hooge007_at_gmail.com wrote:

<snip>
> SELECT distinct EMPLOYEE_ID,FIRST_NAME into v_id, v_fname
> FROM myemp where employee_name=name;
<snip>

Smells like the effects of comparing VARCHAR2 and CHAR fields.

Could you post a DESCRIBE of myemp?

Jaap. Received on Wed Mar 22 2006 - 03:12:02 CST