| Trigger error [message #84631] |
Wed, 07 April 2004 06:14  |
MEDHA
Messages: 6
Registered: February 2004
|
Junior Member |
|
|
hi All,
I want to fill a grid in my form when i change an item in the list box. i.e fill grid based on item change in list box.
now the combo box is in a manual datablock and the grid is in the datablock with table attached to it.
but now i'm getting the error -
WHEN-LIST-CHANGED TRIGGER RAISED UNHANDLED EXCEPTION ORA-01422.
can u'll pls help me in this??
regards
Medha.
|
|
|
|
| Re: Trigger error [message #84636 is a reply to message #84631] |
Wed, 07 April 2004 23:32  |
dipankar saha
Messages: 36
Registered: March 2004
|
Member |
|
|
medha,
the error u have got is cos of the query with which u r filling the grid the no of rows fetched r inconsistent.
i am giving the actual definition of the error
ora-01422 , this might help
ORA-01422 exact fetch returns more than requested number of rows
Cause: The number specified in exact fetch is less than the rows returned.
Action: Rewrite the query or change number of rows requested.
best of luck
from dipankar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
