Hi Everyone, I want mail a Oracle reports 6i report using a unix shell script? Could anyone please help. Also can Oracle forms 6i invoke a shell script. The world is a stage, but the play is badly cast

==> Oracle Reports: I'm using Oracle Reports 10.1.2.0.2. But, it should be the same. 1. You could use: DESTYPE command line option when you run the report: MAIL "MAIL Sends the output to the mail users specified in DESNAME. You can send mail to any mail system that works with SMTP. Note: The configuration file server_name.conf must include the outgoing mail server name. This applies in both the Windows NT and UNIX environment." 2. You could mail the existing report output: see http://www.orafaq.com/scripts/unix/mailx.txt ==> Oracle Forms: I'm using Oracle Forms 10.1.2.0.2. 1. You could use: A. In Forms: Use User Exit built-in, ORA_FFI built-in, Host command B. In DB: Use library: For example: CREATE LIBRARY ext_lib AS '/OR/lib/ext_lib.so'; / Luke Chi

Could you explain it a lil bit more what does destype and desname do? Can I invoke a script from oracle say a trigger? The world is a stage, but the play is badly cast

==> 1 In Oracle Reports: desname: email address. For example: chei@yahoo.com destype: MAIL ==> 2 It's not so straight forward. You'll have to do some reasearch on LIBRARY. (Oracle SQL Reference) "CREATE LIBRARY Purpose Use the CREATE LIBRARY statement to create a schema object associated with an operating-system shared library. The name of this schema object can then be used in the call_spec of CREATE FUNCTION or CREATE PROCEDURE statements, or when declaring a function or procedure in a package or type, so that SQL and PL/SQL can call to third-generation-language (3GL) functions and procedures." So, the PL/SQL in the DB trigger will call your Java or C program and your Java or C program will run the shell script. Luke Chi