Re: newbie:SQL*Reportwriter; RUNREP accepting parameters

>
> In article <3hrqcs$p3l_at_newsbf02.news.aol.com> dougf1_at_aol.com (DougF1) writes:
> >in the middle of a looping construct (in C or PL-SQL), I am picking up
> >fields from a table and trying to pass them through a RUNREP statement to
> >ReportWriter, to execute one seperate report per iteration.
> >Unfortunately, none of my Oracle V6 references show proper syntax for
> >this, and nothing seems to be working.
> >
> >Have you done this? If so, what is the RUNREP syntax for accepting
> >parameters (parameters' values are field values from a table)?
> >
> >Thanks in advance,
> >
> >your pal Doug.
>

I'm having the same problem. I believe the answer is, "You can't do that." In SQLPLUS everything to the right of the HOST command is past as a literal. You can pass parameters to RUNREP but they can't be variables. (The variable's name will be past as the value of the parameter.) If I'm wrong please let me know.

HOST RUNREP test_report po/po ARG1=parm

For example, if parm was defined as a variable (variable parm char(10)) and you assigned it a value (:parm := 'ABC';). Then the above HOST command would place the value 'parm' in ARG1. Received on Mon Feb 27 1995 - 21:25:33 CET