[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1521
  • Last Modified:

How to pass multi-value parameter to Oracle Report

Hi Experts

I want to pass a multi value paremeter from Oracle form to Oracle Report

how can i do that ??
many thanks in advance
0
mohammedf
Asked:
mohammedf
  • 2
2 Solutions
 
MarkusIdCommented:
Hi,

You can only pass date, number or char-variables to reports, but
no arrays (i suppose that's what meant by multi value parameter)).
The workaround for this is to work with a table as interface.
(You fill the table in the calling application, give some unique
number for your records in the table and pass this number to
reports, reports only fetches those from the table that have
the passed number, so you can be sure that reports running at the
same time don't interfere with each other)
0
 
lilian-arnaudCommented:
the other solution is to concatenate all yours parameters with a separator in one single parameter, and split it in the before report trigger.
0
 
mohammedfAuthor Commented:
MarkusId:

thanks , but i dont want to make any new tables

lilian-arnaud:
thanks for ur answer..

but how can we do that please ???!!

thannks

0
 
lilian-arnaudCommented:
could you give us an example of what you want to do with your multi-values parameter ?

do you want to use it in a Sql restriction ?
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now