Reading record just inserted?
From: Norm Russell <nrussell_at_etc.bc.ca>
Date: 1995/06/06
Message-ID: <1995Jun7.005328.7083_at_news.etc.bc.ca>#1/1
which I'd expect to return the sequence # just assigned in the DB's before insert trigger. But it doesn't? It can't find any data? Yet the record has been inserted correctly with the sequence #.
Date: 1995/06/06
Message-ID: <1995Jun7.005328.7083_at_news.etc.bc.ca>#1/1
Hi there,
I have the situation where I'm inserting a record into a table, using Oracle Forms 4.0.
There is a BEFORE INSERT trigger on the table which assigns a sequence number to the primary key of the record I'm inserting.
How can I immediately return this sequence # to Oracle Forms?
I've tried the following and it doesn't work: Call the COMMIT_FORM built-in routine to insert the new record. Then do a SELECT id
INTO :something
FROM... WHERE ....
which I'd expect to return the sequence # just assigned in the DB's before insert trigger. But it doesn't? It can't find any data? Yet the record has been inserted correctly with the sequence #.
Does anybody have any experience with this?
Norm
-- Norm Russell | Phone: +1 (604) 389-3358 British Columbia Systems Corporation | Fax: +1 (604) 360-7116 4000 Seymour Place (2PL, W228) | EMail: nrussell_at_galaxy.gov.bc.ca Victoria, B.C. CANADA V8L 3S3 | http://www.etc.bc.ca/~nrussellReceived on Tue Jun 06 1995 - 00:00:00 CEST