My Oracle Support Banner

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 later
z*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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.