Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reports and forms
Hi Burt,
in case you still need some light to be shed on that issue :
pl_id is NOT a string !
It is the parameter_list-id a handle to a parameter_list you have to
access via Forms-built-ins. Unfortunately I don't have the docs
available here, were I'm raking through newsgroups, so I can't tell
you the exact syntax. pl_id is of type PARAMETER_LIST or so and the
built-in to use is sth like ADD_PARAMETER.
Hth a little bit,
Ansgar
BuRT wrote:
>
> Hi there!
>
> I have managed to figure out how Reports works, as well as the printing
> of an invoice with it.
>
> I have managed to via dos pass it paramaters for which invoice to print.
>
> But I am still a bit flabbergasted as far as running it from Forms 4.5
> goes.
>
> I get the report to run, but I do not get the paramater passed!
>
> Here is the dos command line:
>
> r25run32 invprnt2.rdf garfield/garfield p_transno='00005' paramform=no
> destype=printer desname="IBM Proprinter II" printjob=no
>
> This works fine!!! (p_transno is the paramater)
>
> But running a dos batch file 1000 times could amount to some hairy time
> consumption, thus I'm looking for a way to pass the paramater with forms
> in the run_product command:
>
> Run_Product(REPORTS, 'invprnt2.rdf', ASYNCHRONOUS,
> BATCH, FILESYSTEM, pl_id, NULL);
>
> Where pl_id is the paramater string.
> I have tried 'p_transno=00005', '00005', 'p_transno = 00005', and a lot
> more.
> I just can't get it going!
>
> My objective is to use a cursor and while zooming thru a table, to generate
> invoices in the background by means of the reference number I send it.
>
> If anyone could turn my night to day here it would be muchos appreciated!
> The problem is just passing the paramater!
>
> Ta!
>
> BuRT
-- Ansgar Seiter Group Prof. Ch. Schlier Department of Physics University of Freiburg Phone: +49 761 203-5730 Hermann-Herder-Str. 3 FAX: +49 761 203-5873 D-79104 Freiburg i.Br E-Mail: ansgar.seiter_at_physik.uni-freiburg.de GermanyReceived on Thu Dec 18 1997 - 00:00:00 CST