In PL/SQL you cannot just do a SELECT. It must be either INSERT INTO [table]..SELECT or SELECT..INTO [variables] If you just want to send email using known parameters (no need to do any SELECT) just call this function direcly as below RETURN_VAR := function( [function arguments here] ); Therefore for SEND_MAIL you would have RETURN_VAR := SEND_MAIL( [function arguments here] ); : ' : If I call the send_mail in a select statement in a trigger, : oracle tells me that it is expecting an "into" clause. : Do I have to set up a stored procedure to execute from the trigger? : What is the syntax of the send_email function to simply send an email with : the : Your help is greatly appreciated. : Thanks very much. : Sal Emma
|