I have a form with a header or key block and a detail block with personal information coming from table spbpers and aid information coming from table rjrsear. In the detail block I have query data source name: SPBPERS left join RJRSEAR on RJRSEAR_PIDM = SPBPERS_PIDM and RJRSEAR_AIDY_CODE = :keyblck_aidy_code
.I have WHERE clause:
SPBPERS_PIDM = :keyblck.pidm
. When I do next-block to the block on the form I get the messages FRM-40505 Oracle error: unable to perform query and ORA-01008 not all variables bound, with the query shown having the colon still before the keyblck_aidy_code and 3 extra conditions ANDed into the WHERE clause.
When I use a constant for the keyblck_aidy_code I get good results for a student who has aid (rjrsear) data but a message that the query retrieved nothing for the student who has no aid data.
How should I compose my Query Data Source Name?
I get good results for both students in SQL*Plus.
