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"
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
- Do not modify the default “Siebel Content Enrichment Init” job as already mentioned in the documentation "No change needed" to avoid this error.
- If you are still facing this issue after adhering to documentation then contact CAST Technical Support with relevant input.