[Babel][R] Inclusion of multi-line named code blocks in R code

[Alexander Vorobiev <alexander.vorobiev@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 787 bytes --]

I have R code which submits SQL statements to a database server. Since the
SQL is rather complex, I want to put it into a separate code block in order
to have proper formatting, syntax highlighting, etc:

#+name: long-sql
#+begin_src sql
    select *
    from many, tables
    where
        complex_condition1 = 1,
        complex_condition2 = 2
#+end_src

* Load the data to R session
#+begin_src R :session *R* :noweb yes
    result <- submit_query('<<long-sql>>')
#+end_src

Unfortunately, the R block doesn't work. When I open the file generated by
Babel, I see this:

result <- submit_query('select *
result <- submit_query('from many, tables
etc

instead of the one R submit_query call with my SQL statement as an
argument. Is there anything I can do to achieve that?

Thanks
Alex

[-- Attachment #2: Type: text/html, Size: 1172 bytes --]