Kbase 17030: PROGRESS is not seeing your ORACLE sequences ? Here's why !
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
PROGRESS is not seeing your ORACLE sequences ? Here's why !
The ORACLE DataServer product uses ORACLE sequences whose name finish
with _SEQ for RECID support.
You cannot pull a ORACLE sequence whose name finish with a _SEQ name.
The behavior you'll see is just that those sequences won't show up on
the list of ORACLE objects to be pulled. When you go do a schema pull
(via either DataServers->ORACLE Utilities->Create DataServer Schema or
DataServers->ORACLE Utilities->Update/Add Table Definitions), if you
give a Pre-Selection Criteria for Schema Pull that finds only sequence
objects whose names finish with _SEQ, PROGRESS will give the error:
"There are no objects in the ORACLE database that satisfy the selected
criteria.
(Remember: some data sources are case sensitive.)
Reenter preselection criteria?"
If the sequences you are attempting to pull were not created for
application use, just don't attempt to pull those sequences.
If the sequences you are attempting to pull were created for
application use, and they do finish with _SEQ, you will have to rename
them to a name not finishing with _SEQ.
MAP (07/11/97)
Progress Software Technical Support Note # 17030