Call Stored Procedure from IFB File using SESSION SQL giving ORA-00942 error. (Doc ID 481347.1)

Last updated on JULY 15, 2015

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.1 [16161] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Professional)
Version: 7.5.3.8 [16192]
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: HP-UX 11i

This document was previously published as Siebel SR 38-1786140171.
***Checked for relevance on 15-JUL-2015***


Symptoms

We need to recall a stored procedure (VO_CARICAMENTO_EIM_BIS) from an ifb file.
The ifb file that I have created is like following.


...
[Load EIM Table]
      TYPE = IMPORT
      TABLE = EIM_SRC
      SESSION SQL = "call siebel.VO_CARICAMENTO_EIM_BIS()"
      BATCH = 999
      ONLY BASE TABLES = S_SRC
...

    
When i execute the EIM task ' obtain following error

GenericLog    GenericError    1    2005-02-17 16:13:12    
GenericLog    GenericError    1    2005-02-17 16:13:12    Error 107: ODBC error 42S02:
GenericLog    GenericError    1    2005-02-17 16:13:12    [DataDirect][ODBC Oracle driver][Oracle]ORA-00942: table or view does not exist
GenericLog    GenericError    1    2005-02-17 16:13:12    (native error 942)
Trace    Trace    3    2005-02-17 16:13:12    2/17/05 16:13 Warning: Pre-session SQL statement for [Load EIM Table] failed.
GenericLog    GenericError    1    2005-02-17 16:13:12    
GenericLog    GenericError    1    2005-02-17 16:13:12    -------------------------------------------------------------------------------
GenericLog    GenericError    1    2005-02-17 16:13:12    
GenericLog    GenericError    1    2005-02-17 16:13:12    Process [Load EIM Table] had a failure:
GenericLog    GenericError    1    2005-02-17 16:13:12     User-specified SQL statement failed. (severity 2, table aborted)
GenericLog    GenericError    1    2005-02-17 16:13:12    
GenericLog    GenericError    1    2005-02-17 16:13:12    The user-specified "custom" SQL statement to be run at the start of the process
GenericLog    GenericError    1    2005-02-17 16:13:12    caused an error. Processing aborted.
GenericLog    GenericError    1    2005-02-17 16:13:12    
GenericLog    GenericError    1    2005-02-17 16:13:12    SQL statement being executed:
GenericLog    GenericError    1    2005-02-17 16:13:12    call siebel.VO_CARICAMENTO_EIM_BIS()
GenericLog    GenericError    1    2005-02-17 16:13:12    
GenericLog    GenericError    1    2005-02-17 16:13:12    ODBC error 42S02: [DataDirect][ODBC Oracle driver][Oracle]ORA-00942: table or
GenericLog    GenericError    1    2005-02-17 16:13:12    view does not exist
GenericLog    GenericError    1    2005-02-17 16:13:12...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms