This discussion is archived
5 Replies Latest reply: Jun 11, 2012 3:43 AM by BillyVerreynne RSS

Send a PDF attachment in  plsql code.

907035 Newbie
Currently Being Moderated
Hi,

This is regarding automation process.

Im having a one OA request, it will do some insertions and deletions in some tables.

For example : t_tab is table consists of some rows.so i will query the table as

select * from t_tab
where create_date > '01-Jun-2012';

Now this query results should be stored in a PDF format file.and the same file i have to sent to the receiver.


I know how to send a text message ..But the requirement is to make a PDF format file and store the results as an attachment, and send it to receiver.


Please help me on this..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points