EBC: SBL-DBC-00105 - SQL error
(Doc ID 532121.1)
Last updated on OCTOBER 17, 2023
Applies to:
Siebel Tools - Version 7.7.2.6 SIA [18372] and laterz*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.7.2.6 [18372]
Database: Oracle 9.2.0.6
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Sun Solaris 8
This document was previously published as Siebel SR 38-3136796301.
Checked for Relevance on **Dec-20-2011**
**Checked for Relevance on 02/05/2016**
Symptoms
The requirement is to have an External Business Component attached to a table using a working datasource.
For instance, there is one EBC that works well - it is issuing a distinct query to the external database, and is returning the correct records. Trying this with a different business component (created by copying the working buscomp), and have defined the table object and modified the buscomp to use the new columns.
The application is generating the following SQL:
....is quite generic, and the support portal posts for this error and EBCs are not describing the problem (most have to do with joins).
What would be the steps to achieve the requirement?
Changes
.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |