SashaBuilder3
Programmer
Hi everybody,
Newbie questions. I created a stored procedure which reads data from a text file and populates a table with new records using INSERT INTO statement. The procedure works OK when called from within SQL*Plus environment.
Now I want to make a form called for the same job - loading the table. I created a data block, placed an item - push button, added to it a trigger WHEN-BUTTON-PRESSED and copied the procedure here. It compiles without problems and even starts working - it reads a first line from the file but stops on INSERT INTO statement giving an error message:
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01830.
Can anyone tell me what is going on? By the way, where can I find a list of all those ORA-XXXXX exceptions?
One more thing. At some point in the procedure I use the Trim() function. But in Forms it gives me a compilation error (Identifier TRIM must be declared). Why doesn't the Forms recognize it?
Thanks,
Alexandre
Newbie questions. I created a stored procedure which reads data from a text file and populates a table with new records using INSERT INTO statement. The procedure works OK when called from within SQL*Plus environment.
Now I want to make a form called for the same job - loading the table. I created a data block, placed an item - push button, added to it a trigger WHEN-BUTTON-PRESSED and copied the procedure here. It compiles without problems and even starts working - it reads a first line from the file but stops on INSERT INTO statement giving an error message:
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01830.
Can anyone tell me what is going on? By the way, where can I find a list of all those ORA-XXXXX exceptions?
One more thing. At some point in the procedure I use the Trim() function. But in Forms it gives me a compilation error (Identifier TRIM must be declared). Why doesn't the Forms recognize it?
Thanks,
Alexandre