Create Procedure SendReport()
BEGIN
DECLARE query_report VARCHAR( 256 ) DEFAULT
'REPORT "universal_report"."Report_Event_Artist"
FROM \"mssql://host = 10.0.0.117 port = 1433 dbname = eios user = eios password = eios timeout=10 datalimit=65535 \"
USING \'SELECT * FROM Event_Artist\'
AS PDF ENCODE BASE64';
DECLARE cursor_report CURSOR FOR query_report;
OPEN cursor_report;
FETCH FIRST cursor_report INTO @report_data;
CLOSE cursor_report;
__MAIL
__FROM 'brad.whitehead@gmail.com'
__TO 'tom@luckymanonline.com'
__SUBJECT 'The Artist List'
__BODY 'View attachment, please.'
__ATTACH @report_data AS 'event_artist.pdf'
__SMTP 'smtp://smtp.gmail.com'
__PORT 465
__USER 'brad.whitehead@gmail.com'
__PASSWORD 'ZZZZZZZ'
__SSL TRUE;
END
When I try to create the procedure, I receive the error: Expecting "__smtp", Found "__SMTP". and the log has: "Kernel error: 0x71000. line 19:9: expecting "__smtp", found '__SMTP' "
This is Vserver 13.3 running on Ubuntu 22.04, with VStudio Pro 13.3.3. The VServer sees and can access the MS SQL database.
What am I doing wrong? Thanks