To return expected results, you can:
Reduce the number of search terms.
Each term you use focuses the search further.
Check your spelling.
A single misspelled or incorrectly typed term can change your result.
Try substituting synonyms for your original terms.
For example, instead of searching for "java classes", try "java training"
Did you search for an IBM acquired or sold product ?
If so, follow the appropriate link below to find the content you need.
Administrator launches Controller Configuration, and chooses database. Administrator clicks the 'Run' button which launches the 'Database Conversion' utility.
Administrator clicks the 'Run Steps' button, to upgrade the database to the latest version.
After a while, an error appears.
When running steps:
Running script: script/ora/ora_create_view_vxnyst_c4.sql
Running script: script/ora/ora_create_view_vxnyst_cf.sql
Running script: script/ora/ora_create_view_vxnyst_uc.sql
Running script: script/ora/ora_create_view_vxnyst_uf.sql
Running script: script/ora/ora_create_view_vxnyst_um.sql
Running script: script/ora/ora_update_xmenu.sql
Running DB Step: 949
Running script batch: script/ora_949.batch
Running script: script/ora/ora_update_trg_saxuser.sql
Running DB Step: 950
Running script batch: script/ora_950.batch
Running script: script/ora/ora_update_xmenu.sql
Running DB Step: 951
Running DB Step: 952
Running script batch: ora_952.batch
Running script: script/ora_xrclayout_add_column.sql
** ERROR: java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier
ORA-06512: at line 12
Swedish:
** ERROR: java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."SUBSTR": ogiltig identifierare
ORA-06512: vid rad 12
Modify the permissions for the relevant schema, so that it can use the Oracle package "dbms_Lob".
Steps:
1. On the application server, launch 'Controller Configuration'
2. Open 'Database Connections'
3. Select the relevant connection
4. Make a note of the value 'User ID'
This is the schema name
5. Ask the Oracle administrator (DBA) to assign rights to the relevant Oracle packages, for example by running scripts similar to:
grant execute on dbma_lob to <schemaname>;
grant execute on dbms_lob to <schemaname>;