| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> from my previous posting "Forms: problem with parameter"
I would like to thank Steve Cosner for his suggestion.
If someone else experience same problem the following code will be valuable:
sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN To_date('''
||to_char(:DATE_BLOCK.START_PLAN,'YYYYMMDD')
||''',''YYYYMMDD'') AND To_date('''
||to_char(:DATE_BLOCK.END_PLAN,'YYYYMMDD')
||''',''YYYYMMDD'')'
||' ORDER BY CALIBRACAO.PROXIMA';
Received on Sun Jul 25 1999 - 17:35:32 CDT
 |
 |