Oracle Reports (3.0) lexical references

From: Douwe Doornbos <d.doornbos_at_rc.rug.nl>
Date: Thu, 13 Jan 2000 10:29:14 GMT
Message-ID: <85k9fk$pr9$1_at_info.service.rug.nl>



Hi,

I'm investigating Reports 3.0/Developer 2000. I'm trying to use lecical references as part of a tablename in a SQL-statement. But it seems that Reports is placing white space in front of the parameter causing invalid SQL.

Suppose a parameter num equal to '223'. Then I would like 'table&num' to be converted to 'table233' and not to 'table 223'.

Can anybody help me with this? Is theer an other way to accomplish this?

With kindly regards,

Douwe.

--
  Douwe Doornbos
  d.doornbos_at_rc.rug.nl
  http://come.to/doornbos
Received on Thu Jan 13 2000 - 11:29:14 CET

Original text of this message