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