Re: Drill down reports with WebDB
Date: Wed, 11 Aug 1999 10:08:59 GMT
Message-ID: <7ori3o$uq8$1_at_nnrp1.deja.com>
In article <7nhpfi$shi$1_at_ra.nrl.navy.mil>,
"Heidi Schuerger" <schuerger_at_utopia.nrl.navy.mil> wrote:
> Having problems passing values when drilling down in WebDB reports.
> Specifically, passing multi-selected parameters used in highly
summarized
> report (Directorate level personnel summary) need to be passed to
Department
> level personnel summary.
>
> If one value is selected in the multi-select, the report runs.
> If more than one value is selected, the report fails:
>
> ORA-01001: invalid cursor
> Failed to bind - :date2 with 03-jul-99
>
> ORA-01001: invalid cursor
> Failed to bind - :zz81 with F
>
> ORA-01001: invalid cursor
> Failed to bind - :zz82 with I
>
> ORA-01001: invalid cursor
> Failed to bind - :zz83 with P
>
> ORA-01001: invalid cursor
> Cursor is not open
>
> No row returned.
>
> Any ideas?
>
>
Your probably using = while you should be using in or in list
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Aug 11 1999 - 12:08:59 CEST