Problem Description

The "Siebel Content Enrichment Init" job is failing with the following error :

Error    SQL Error: ORA-06550: line 7, column 12
Error    SQL Error: PLS-00306: wrong argument number or types when calling "SIEBEL_TECHNICAL"
Error  SQL Error: ORA-06550: line 7, column 2:.
Error  SQL Error: PL/SQL: Statement ignored (Severity 1, Msg No 6550).
Error  Failed to launch SQL Queries

This error was observed in CAST 7.0.12 with Siebel Package 4.0.5 on RDBMS Oracle 11g

Reason


This error occurs when one tries to modify the “Siebel Content Enrichment Init” job by passing parameters to "SIEBEL_TECHNICAL" function.
“Siebel Content Enrichment Init” job is an SQL tool job which has the following content by default:

Declare
    Result INTEGER;
Begin
    Result := $(KBName).SIEBEL_TECHNICAL ();
    Result := $(KBName).SIEBEL_DISCRIMINATION_DATA('Project');
End;

If the knowledge base is checked for the “SIEBEL_TECHNICAL” function, it has no parameters to be passed.

But if the job is modified like something below :

SQL=Declare
    Result INTEGER;
    JOB_NAME VARCHAR2(255);     -- Input parameter
Begin
    -- JOB_NAME is the name of the UI/UA job
    JOB_NAME := 'Project';
    Result := $(KBName).SIEBEL_TECHNICAL (JOB_NAME);
End;


It can be noticed that there is parameter JOB_NAME passed which is unacceptable by SIEBEL_TECHNICAL () function.  Hence the error occurs wrong argument number or types when calling "SIEBEL_TECHNICAL"

 

Applicable in CAST Version
Release
Yes/No
8.3.x(error)
8.2.x(error) 
8.1.x(error) 
8.0.x (error) 
7.3.x(error)
7.2.x(error)
7.0.x(tick)
Action Plan
  1. Do not modify the default “Siebel Content Enrichment Init” job as already mentioned in the documentation "No change needed" to avoid this error.
  2. If you are still facing this issue after adhering to documentation then contact CAST Technical Support with relevant input.
Notes

 

Related Pages