Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    15

    Unanswered: Problem with lovs

    hello

    I'm novice in forms and i'm getting a problem with LOVs.
    The situation is like this:

    Resuming my problem, I've got two tables:

    table 1 (organism)

    field name: name type: varchar2(50)
    field name: id type: integer
    field name: org_id type: varchar2(50)
    FOREIGN KEY (org_id) REFERENCES organism_type (id)

    table 2 (organism_type)

    field name: name type: varchar2(50)
    field name: id type: integer

    my form is composed with two blocks

    block 1
    organ (based table organism)

    block 2
    org_type (based table organism_type)

    Then, in my canvas I've two fields

    text Item 1
    org_type.name

    text Item 2
    organ.name

    Each field is related with a respective LOV (LOV1 for org_type.name, LOV2 for organ.name), so that the user must choose a value from a LOV in both fields.

    The problem is that I want to depend the results of the second field (organ.name) from the first field (org_type.name). In the first field, the user choose a name of a organism_type in a LOV1, then I want to pick up that name and his corresponding id to filter the values of the second LOV2 (suposing there's only distinct names with distinct id's). The query of the second LOV should seems like this:

    select o.name
    into rgan.name
    from organism o
    where o.id = rg_type.id

    and the values would be filtered.
    When I Compile the form I get this errors:

    FRM-30064: Unable to parse statement
    select o.name
    into rgan.name
    from organism o
    where o.id = rg_type.id
    ORA-01745:invalid host/bind variable name
    Record Group ORG
    Form: ORG
    FRM-30085: Unable to adjust form for output.

    What am i doing wrong, and what alternatives do i have to override this problem.

    Thanks and Regards.

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    LOVs do not need INTO statements that ability is handled in your "column mapping" properties. You should just be able to use the :column namd notation for referring to the output of your other LOV.
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Jan 2004
    Posts
    15
    Originally posted by Todd Barkus
    LOVs do not need INTO statements that ability is handled in your "column mapping" properties. You should just be able to use the :column namd notation for referring to the output of your other LOV.
    Orait, i suppose the error comes from that... i'll try it again ..
    Thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •