Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can trigger processing be separated from insert?

441298Jul 30 2009 — edited Jul 30 2009
When inserting a record via jdbc, will making the insert trigger for the table 'AFTER INSERT' return control back to external app before the trigger is processed? I have a trigger that's sending mail and am trying find some way to decouple the insert from the smtp send.

Comments

Hello,
UNC paths usually are restricted due to the security nature of Oracle Report.
Added <folderAccess> element in rwserver.conf file

<folderAccess>
<read>O:\temp\*</read>
<write>O:\temp\*</write>
</folderAccess>

Add this line to setDomainEnv.cmd script in $DOMAIN_HOME/bin directory
NET USE O: \\server01\my_directory /user:<userid> <password>
where:
O: – is the mapped drive letter
\\server01\my_directory – is the root of remote file system
<userid> – name of user authorized to connect to remote file system.
<password> – password for <userid>
then you can use O:\file to access files within my_directory
Thanks, Suresh

user6532048

I did add the drive from file explorer, I can access the new drive in the file explorer.
Is that I also need to add "NET USE" in setDomainEnv.cmd?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 27 2009
Added on Jul 30 2009
#database, #performance, #plsql, #trigger
4 comments
498 views