Re: Strange behaviour in SET_REPORT_OBJECT_PROPERTY

On 27 Feb, 18:58, "shakespeare" <what..._at_xs4all.nl> wrote:
> "nick048" <nicosia.gaet..._at_moonsoft.it> schreef in berichtnews:e75b09e8-75db-42b5-9618-be91723981a9_at_p25g2000hsf.googlegroups.com...
>
>
>
> > Hi,
>
> > I need to run a report from a Form.
> > The Report Parameter are stored in a table and with this parameters I
> > want to set the report properties
>
> > Now if I use this statement (this is an example):
>
> > SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_DESFORMAT,
> > MYTABLE.REP_DESFORMAT);
>
> > the property is set correctly.
>
> > But If I use this code:
>
> > DECLARE PR$Format VARCHAR2(100);
> > .....
> > BEGIN
> > SELECT REPORT_DESFORMAT
> > INTO PR$Format
> > FROM MYTABLE
> > WHERE ........
> > SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_DESFORMAT, PR$Format);
> > .......
> > END;
>
Yes, I have tested the values returned from statement Select.

Bye
Gaetano
> > the parameter is not set.
>
> > And so for the others parameters. I do not understand this curious
> > behaviour.
>
> > Can anyone help me ?
>
> > Greetings...
> > Gaetano
>
> Are you sure the select statement returns one and only one value? No
> exceptions?
>
> Shakespeare
Received on Thu Feb 28 2008 - 11:10:10 CET