SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
attach error (continued...)

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
attach error (continued...)
Author Message
Leonardo Rozas



Joined: 14 Mar 2001
Posts: 1

Post attach error (continued...) Reply with quote

:Have you installed the correct DB Mail interface functions?

:There are 3 files provided with DB Mail

:db_mail_install_7.sql for Oracle 7
:db_mail_install_8.sql for Oracle 8.0.0 to 8.1.4
:db_mail_install_8i.sql for Oracle 8.1.5 and later

:The error you are getting could be a result of db_mail_install_8.sql used for :Oracle 8i database.

Well, we have Oracle version 8.0.6 for Windows NT, so I used the scripts in db_mail_install_8.sql to create DB Mail interface functions.

Do you think that it is better to use ...install_7.sql in this case (Oracle 8.0.6), because it's easy to see that the script that I used is the script indicated by SoftTree for versions 8.0.0 to 8.1.4. More thanks...

Wed Mar 14, 2001 1:04 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: attach error (continued...) Reply with quote

Ok, Run db_mail_install_8i.sql

The only real difference between these two scripts is PRAGMA AUTONOMOUS_TRANSACTIONS that allows updates in functions. This is needed because of incompatible behavior of different Oracle versions.

: Well, we have Oracle version 8.0.6 for Windows NT, so I used the scripts in
: db_mail_install_8.sql to create DB Mail interface functions.

: Do you think that it is better to use ...install_7.sql in this case (Oracle
: 8.0.6), because it's easy to see that the script that I used is the script
: indicated by SoftTree for versions 8.0.0 to 8.1.4. More thanks...

Wed Mar 14, 2001 2:59 pm View user's profile Send private message
Leonardo Rozas



Joined: 14 Mar 2001
Posts: 1

Post Re: attach error (continued...) Reply with quote

: Ok, Run db_mail_install_8i.sql

: The only real difference between these two scripts is PRAGMA
: AUTONOMOUS_TRANSACTIONS that allows updates in functions. This is needed
: because of incompatible behavior of different Oracle versions.

... if you think this is correct, but is AUTONOMOUS_TRANSACTIONS supported by Oracle 8.0.6 ?

In the script there is a comment beside the instrucion PRAGMA ... it says
/* Oracle 8i only e.g. Oracle 8.1.5 and later */

This is what lets me worried. Thank you, I'm going to wait your answer before changing the scripts.

Wed Mar 14, 2001 3:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: attach error (continued...) Reply with quote

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;

: ... if you think this is correct, but is AUTONOMOUS_TRANSACTIONS supported by
: Oracle 8.0.6 ?

: In the script there is a comment beside the instrucion PRAGMA ... it says
: /* Oracle 8i only e.g. Oracle 8.1.5 and later */

: This is what lets me worried. Thank you, I'm going to wait your answer before
: changing the scripts.

Wed Mar 14, 2001 4:30 pm View user's profile Send private message
Leonardo Rozas



Joined: 14 Mar 2001
Posts: 1

Post Re: attach error (continued...) Reply with quote

: 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...

Wed Mar 14, 2001 5:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: attach error (continued...) Reply with quote

The syntax for CREATE DIRECTORY is correct.

: 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...

Wed Mar 14, 2001 5:52 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.