| Oracle Forms - Implementing set scan off in pl/sql [message #79846] |
Thu, 18 July 2002 01:41  |
Riz Aziz
Messages: 5
Registered: July 2002
|
Junior Member |
|
|
Hi
In this particular case the database block - has an item named consumer_name. The code in the text item
is selecting company names, with '&'in e.g. A&E Motors. The system passes this information where the name and other relevant details are processed for extraction. But fails to produce a report/extraction with Company Names with an '&'
Using the Data extract screen if customer name has a "&" character, the extract fails. Change processing so that SAS system does not treat the above as a special character.
In sql*plus you can use set define off or set scan off,
which works
But with set scan on and set define on You get this
1 select code,description from consumers
2* where description = 'MARLEY FLOORS & WATERPROOFIN'
SQL> /
Enter value for waterproofin:
How can I implement using set scan off in Oracle forms, if not could you please shed some light on the above message.
Kind regards
Riz
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
