| FRM-40735 [message #480307] |
Fri, 22 October 2010 06:29  |
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
|
Senior Member |
|
|
I create a form to create report in excel sheet
i take 3 field on my screen
1) Location
2) fROM DATE (Format mask is 'DD-MON-RRRR')
3) TO date (Format mask is 'DD-MON-RRRR')
when i place excel button to create excel conversion i get follwing error..
FRM-40735:WHEN BUTTON-PRESSED TRIGGER raised unhandled exception
ORA-01847.
My Code behind excel button is (WHEN-BUTTON-PRESSED) :
IF :BLK_ENTER.LOC != ' ' AND :BLK_ENTER.FROM_DATE != ' ' AND :BLK_ENTER.TO_DATE != ' ' THEN
FILE_OPEN;
EXCEL_P;
END IF;
May i know where i did exactly mistake???
|
|
|
|
| Re: FRM-40735 [message #480318 is a reply to message #480307] |
Fri, 22 October 2010 07:30  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
1) Can you please read and follow the orafaq forum guide especially the part about formatting your posts.
2) Why are you checking that date fiels are not equal to space?
3) Is excel_p a procedure? If so the error is probably in there. Run the form in debug mode or use messages to fins out what exact line of code is raising the error and we may be able to tell what the problem is.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
