Ask the Expert

Sending faxes using database triggers

I wish to know how I can send a fax to people using database triggers to capture values entered in specific columns.

    Requires Free Membership to View

Oracle will not let you send faxes natively from the database. So you'll need faxing software of some sort on your database server. Some faxing software will be able to receive email while others will be able to read the data from a disk file. Depending on your software, you can code your trigger to use the UTL_SMTP package to send an email or use the UTL_FILE package to generate a disk file. Then you'll have to figure out how to fire up the faxing software!

For More Information

This was first published in May 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: