executing compiled pl/sql code from forms4.5

I have 5 packages of procedures and functions which I have written to edit data. I did not use procedure builder. I wrote code and compiled it in the database. (the OS is Windows 95) The DEV2K that I am using uses PL/SQL 1.1 something, while the database uses 2.2 something. The code compiles. I can execute the code from SQL Plus using the EXEC pkgname.procname syntax. It runs fine. BUT.... I want to run the code from an ON-EXIT trigger form FORMS 4.5. When the trigger fires, I send a message to the screen before the call to the stored procedure. The message displays and then nothing happens. I get no errors, but I can't continue. If I comment out the reference to the stored procedure, the trigger completes. Once I hit this code, I'm dead in the water. Oh, I can get the code to execute from forms by issuing a host command to execute sqlplus and run a little sql code, but surely there is a better way. Has anybody out there had any problems running stored procedures from within forms? This code has dynamic SQL in it , could that be a problem? Any ideas would be greatly appreciated. - C. Handy Received on Sat Jan 25 1997 - 00:00:00 CET