Re: Strange behaviour in SET_REPORT_OBJECT_PROPERTY

"nick048" <nicosia.gaetano_at_moonsoft.it> schreef in bericht news: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;
>
>
> 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 Wed Feb 27 2008 - 18:58:00 CET