Nntp_post is used to post a message to the server running the Network News Transfer Protocol as defined in the rfc977.
1 on success or error
| SQLState | Error Code | Error Text |
|---|---|---|
| 2E000 | NN011 | Invalid address for News Server at [host] |
| 08001 | NN012 | Unable to Contact News Server at [host] |
| 08006 | NN013 | Misc. error in connection in nntp_post |
This example post message to a remote NNTP server.
SQL> set MACRO_SUBSTITUTION off;
SQL> select nntp_post ('news.openlinksw.co.uk:119',
'From: "Demo User" user@demo.com\r\nSubject: Test Virtuoso nntp_post function\r\nNewsgroups: openlink.public.test\r\n\r\nTEST IS OK.\r\n\r\n.\r\n') ;
callret
VARCHAR
_______________________________________________________________________________
1
1 Rows. -- 782 msec.
SQL>