Name
nntp_post — Post message to NNTP server
Synopsis
array
nntp_post
(
|
in server varchar , |
in
body
varchar
); |
Description
Nntp_post
is used to post a message to the server running
the Network News Transfer Protocol as defined in the rfc977.
Parameters
server
The host to connect with. IP address or hostname:port. There is no default for port, so to connect to the standard port for NNTP, use <hostname/IP address>:119
body
The body string The structure of the message must comply with RFC 850 (Standard for Interchange of USENET Messages).
Return Types
1 on success or error
Errors
Table 24.59. Errors signalled by
| 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 |
Examples
Example 24.226. Post message to remote NNTP
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>