: Sorry, you are right, the AUTONOMOUS_TRANSACTIONS pragma is not supported by : Oracle 8.0.6 : Are you running send_mail within a transaction? : If not, try opening transaction before running the SQL containing call to : send_mail. : For example : SET TRANSACTION READ WRITE; : .... your code here containing call to send_mail; : COMMIT WORK; I will try this. Now, we've modificated the attach_file function, in exception section. We added raise_application_error(-20001, 'Error was: ' || sqlerrm); after rollback (for when others). The error was: ORA-22285: non-existent directory or file for FILEOPEN operation at "SYSTEM.ATTACH_FILE", line 56 With this, I think that the Oracle directory object has not been correctly created. The instruction was: create or replace directory ADJUNTOS as 'e:\orant\net80\admin'; ... being 'e:\' a local drive in the NT Server that runs Oracle 8.0.6. The mentioned path is correct for the operating system. Is this the right way to create the Oracle directory? or do I have not to use the drive letter? Thanks a lot...
|