Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#41 cascading lov not working when bind variables are used twice

closed-fixed
Patrick Wolf
ApexLib_Lov (7)
5
2007-02-23
2007-02-23
No

Hi Patrick,

I have a lov defined which has some variables twice in the where clause of the select statement.
Now I don't get a select list back. I get an error message in the http post of firebug.
<select><option value="%null%">All</option>Error: ORA-01008: not all variables bound

The select statement is:

select l.lang_desc d, l.lang_cd r
from tablex x
where not exists (select 1
from tabley y
where y.dt_cd = :P2_D
and y.lang_cd = x.lang_cd
and y.name = :P2_C)
and not exists (select 1
from tablez z
where z.dt_cd = :P2_D
and z.lang_cd = x.lang_cd
and z.name = :P2_C
and z.active_ind = 'Y')
order by 1

Kind regards,

Joost van de Wiel

Discussion

  • Patrick Wolf
    Patrick Wolf
    2007-02-23

    • assigned_to: nobody --> patrick_wolf
     
  • Patrick Wolf
    Patrick Wolf
    2007-02-23

    Logged In: YES
    user_id=1449836
    Originator: NO

    I will look into that.

     
  • Patrick Wolf
    Patrick Wolf
    2007-02-23

    • status: open --> closed-fixed
     
  • Patrick Wolf
    Patrick Wolf
    2007-02-23

    Logged In: YES
    user_id=1449836
    Originator: NO

    Fixed in release 1.4