| bad bind variables [message #85814] |
Sun, 01 August 2004 19:40  |
amizam
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
The error occurs when the codes compiled:
Codes compiled:
-- -- Begin default relation declare section --
DECLARE
recstat VARCHAR2(20) := :System.record_status;
startitm VARCHAR2(61) := :System.cursor_item;
rel_id Relation;
-- -- End default relation declare section -- --
-- Begin default relation program section --
BEGIN
IF ( recstat = 'NEW' or recstat = 'INSERT' ) THEN
RETURN;
END IF;
-- -- Begin BOOKS_RESERVED detail program section --
IF ( (:BOOKS_PROFILE.BP_BOOK_ID is not null) ) THEN
rel_id := Find_Relation
('BOOKS_PROFILE.BOOKS_PROFILE_BOOKS_RESERVED');
Query_Master_Details(rel_id, 'BOOKS_RESERVED');
END IF;
-- -- End BOOKS_RESERVED detail program section -- -- --
Begin
-- LOST_BOOKS detail program section --
IF ( (:BOOKS_PROFILE.BP_BOOK_ID is not null) ) THEN
rel_id := Find_Relation
('BOOKS_PROFILE.BOOKS_PROFILE_LOST_BOOKS');
Query_Master_Details(rel_id, 'LOST_BOOKS');
END IF;
-- -- End LOST_BOOKS detail program section -- --
-- Begin BOOKS_BORROWED detail program section --
IF ( (:BOOKS_PROFILE.BP_BOOK_ID is not null) ) THEN
rel_id := Find_Relation
('BOOKS_PROFILE.BOOKS_PROFILE_BOOKS_BORROWED');
Query_Master_Details(rel_id, 'BOOKS_BORROWED');
END IF;
-- -- End BOOKS_BORROWED detail program section -- --
-- Begin BOOKS_RETURNED detail program section --
IF ( (:BOOKS_PROFILE.BP_BOOK_ID is not null) ) THEN
rel_id := Find_Relation
('BOOKS_PROFILE.BOOKS_PROFILE_BOOKS_RETURNED');
Query_Master_Details(rel_id, 'BOOKS_RETURNED');
END IF;
-- -- End BOOKS_RETURNED detail program section --
IF ( :System.cursor_item <> startitm ) THEN Go_Item(startitm);
Check_Package_Failure;
END IF;
END;
-- -- End default relation program section --
Error occured:
bad bind variable 'BOOKS_PROFILE.BP_BOOK_ID'
|
|
|
|
| Re: bad bind variables [message #85825 is a reply to message #85814] |
Mon, 02 August 2004 03:39  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Check if BP_BOOK_ID column exists in 'BOOKS_PROFILE block.
If not then delete the Master Detail relationship & then recreate it again.
Things should work.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
