On Fri, 21 Jun 2002 16:29:19 +0100, "Gaurav Gupta (2000)" <[log in to unmask]>
wrote:

>1)       A user come in and adds an html to be send as a part of certain
>list. He/She also specifies the language and brand while uploading the html.

LISTSERV will not 'store' message content.  It only handles immediate messages.
However, you may be able to store such content in the database and then (see # 2
below) use a SQL SELECT statement to call it out again.

>2)       Now listserv queries the database to get a list of user email id
>who have subscribed to that list and corresponds to that brand and language.

Yes, LISTSERV can be connected to Oracle.  See http://www.lsoft.com/dbms.html
and yes LISTSERV can send email using any valid SQL SELECT statement to extract
any desired data from Oracle.

>3)       Also, in case of subscription, LISTSERV(r) should send a
>pre-confirmation mail and after user has responded to the pre-confirmation
>updates the oracle database with the user email id, list chosen, language
>and brand.

Partly.  LISTSERV can confirm the email address and 'listname' but it will not
confirm the other information.  This needs to be input directly to the database.