APEX

unfortunately, this feels like a question where Tom Kyte's answer would be: the car won't start. ie, I suspect I'm not going to be asking the question properly, because I'm not sure what's wrong. But I'll try to be succinct:

I'm working with 4 tables: Venues, Ven_Add, Addresses, Cities

I have an Interactive report of Venues, leading into a DML. DML has Venue name on top, and, theoretically, the venues addresses in a tabular form below that. Here is the code:

select
ven_add.VEN_ADD_ID,
ven_add.VA_VENUE_ID,
ven_add.VA_ADR_ID,
addresses.adr_ID,
addresses.ADR_LINE_1,
addresses.adr_CTY_ID,
cities.cty_ID,
cities.cty_name
from "#OWNER#"."VEN_ADD", ADDRESSES, CITIES
where ven_add.VA_VENUE_ID = :P122_VENUE_ID
and ven_add.VA_ADR_ID = addresses.adr_id (+)
and addresses.adr_cty_id = cities.cty_id (+)

I thought the problem was caused by my reaching out to the city table via a STATIC LOV that I made, but I don't think that is the problem; even if I eliminate the city-related columns, I get the same error message. In fact, I also tried eliminating the connection to the addresses table, and I still cannot add a new row.

I'm not sure what else to include for ideas on how to solve this. I found other threads about this error, but they seem really old, and I didn't learn anything useful. My join seems ok, since the command works fine in SQL*Workshop (after I alter the code slightly to modif the venue_id equation).

What else can I tell you so you can help me figure this out?

Thank you -
Marion in NY

PS - all 8 columns that are in my source code are included in the tabular report (yes, most of them are unnecessary, but I've included them so I can see that the links are right); I read another post where Andy specified that all selected columns must be included, so I figured I'd include this tidbit