sql - syntax error: unexpected end of file

Question

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
}

Answer 1

The indented heredoc delimiter breaks it. Say:

EOF

instead of

    EOF