I seem to recall that using a %TYPE to define a variable data type created a problem for me as well. Change:
pdCurrDate IN EMP.OUT_DT%TYPE
TO:
pdCurrDate IN DATE
in both places and see if that helps.
>Hi Tim,
>
>Perhaps you are right and I should just have the query Client side where needed in the VFP code. But I was under the idea that if I keep calling the same procedure in different programs, it should go server side. This is a judgement call. As I'm new to packages I might be holding too tight to that doctorine??? The way I see it is, the things I learn in these small package builds, will help later when it counts more.
>
>I've been able to convert the VFP code into a Package that compiles. But I get an error:
>
>
>ORA-06512 Connectivity error: [Oracle][ODBC][Ora]ORA-00904: invalid column name
>ORA-06512: at "PROD.GET_EMP_COMBO_LIST", line 45
>ORA-06512: at line 1
Mark McCasland
Midlothian, TX USA