DB2 Version 10.1 for Linux, UNIX, and Windows

Function invocation syntax support (PL/SQL)

A number of procedures support function invocation syntax in a PL/SQL assignment statement.

These procedures include:

DBMS_SQL.EXECUTE
DBMS_SQL.EXECUTE_AND_FETCH
DBMS_SQL.FETCH_ROWS
DBMS_SQL.IS_OPEN
DBMS_SQL.LAST_ROW_COUNT
DBMS_SQL.OPEN_CURSOR
UTL_SMTP.CLOSE_DATA
UTL_SMTP.COMMAND
UTL_SMTP.COMMAND_REPLIES
UTL_SMTP.DATA
UTL_SMTP.EHLO
UTL_SMTP.HELO
UTL_SMTP.HELP
UTL_SMTP.MAIL
UTL_SMTP.NOOP
UTL_SMTP.OPEN_DATA
UTL_SMTP.QUIT
UTL_SMTP.RCPT
UTL_SMTP.RSET
UTL_SMTP.VRFY

Examples

DECLARE
  cursor1 NUMBER;
  rowsProcessed NUMBER;
BEGIN
  cursor1 := DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(cursor1, 'INSERT INTO T1 VALUES (10)', DBMS_SQL.NATIVE);
  rowsProcessed := DBMS_SQL.EXECUTE(cursor1);
  DBMS_SQL.CLOSE_CURSOR(cursor1);
END;
/

DECLARE
  v_connection UTL_SMTP.CONNECTION;
  v_reply UTL_SMTP.REPLY;
BEGIN
  UTL_SMTP.OPEN_CONNECTION('127.0.0.1', 25, v_connection, 10, v_reply);
  UTL_SMTP.HELO(v_connection,'127.0.0.1');
  UTL_SMTP.MAIL(v_connection, 'sender1@ca.ibm.com');
  UTL_SMTP.RCPT(v_connection, 'receiver1@ca.ibm.com');
  v_reply := UTL_SMTP.OPEN_DATA (v_connection);
  UTL_SMTP.WRITE_DATA (v_connection, 'Test message');
  UTL_SMTP.CLOSE_DATA (v_connection);
  UTL_SMTP.QUIT(v_connection);
END;
/