Web Development



joined tables in Oracle Forms

By john.a.wills ·
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 detai 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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums