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

Table24.60.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

Example24.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>