This content has been marked as final. Show 6 replies
Please explain what you mean by "during an insert it does not".
Are you saying you enter a value and then press some button to start an insert process? How does the insert run?
By the way:
1. Open-Fetch-Close never raises no_data_found exceptions, so the when no_data_found part is wasted space.
2. When Others: Better to display SQLERRM. At least you then get the Oracle error message that caused the error.
3. When you post code, place it between [code] and [/code] tags.
Edited by: Steve Cosner on Apr 25, 2013 10:50 AM
Changed "CODE" to "code"
open cursor loop ... Fetch into ... End loop... Close cursor
put the check for the fk in where clause of the cursor remove second validation then call ur procedure generate & try again.
Now here's the fun part.Well, it would have been fun if you had posted that updating stuff, because there seems to be the error..
I was just typing up a response to you Steve when it hit me, the VEHICLE_ID isn't in the database yet during an insert.
WHERE :VEHICLE.VEHICLE_ID = VEHICLE.VEHICLE_ID AND :VEHICLE.VMODEL_ID = VEHICLE_MODEL.VMODEL_ID;
Now I'm a bit new to Oracle so excuse my ignorance but you and Amatu lost me in your explanation.
WHERE :VEHICLE.VMODEL_ID = VEHICLE_MODEL.VMODEL_ID;
I'm going to mark this as answered but I'd appreciate either a little more detail on what you guys did answer or some links to help me learn a bit more.
The Oracle Peon...
Edited by: Oracle Peon on Apr 25, 2013 11:25 AM
OP: I just realized, when you use code tags, they need to be lower case. (Go back and edit your posts, and see what happens.)1 person found this helpful
Now I'm a bit new to Oracle so excuse my ignorance but you and Amatu lost me in your explanation.I think everyone was confused due to the limited explanation in your first post.
I'm going to mark this as answered but I'd appreciate either a little more detail on what you guys did
answer or some links to help me learn a bit more.