缩进的定界符分隔符打破它。你说：

  EOF
 

而不是

  EOF
 

I have an SQL query that when it is put in to a function it stops working with this syntax error: unexpected end of file error message. Removing it from a function causes it to start working again.

Why is this?

function pull_data
{
    sqlplus -s $user/$pass@$db << EOF
    SELECT DISTINCT order_number,
                    order_total_items,
                    order_total_value
    FROM orders

    WHERE order_date BETWEEN '$1' AND '$2';

    exit;

    EOF
}

The indented heredoc delimiter breaks it. Say:

EOF

instead of

    EOF