IBM Support

ORA-06550 error message when running stored procedure in Cognos

Troubleshooting


Problem

When running a stored procedure in Cognos the user may encounter an UDA-SQL-0107 error message when running agianst Oracle.

Symptom

RQP-DEF-0177 An error occurred while performing operation
'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the
operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception
has occurred during the operation "execute". ORA-06550: line 1, column
17: PLS-00302: component 'xxx' must be declared ORA-06550:
line 1, column 7: PL/SQL: Statement ignored

Cause

This is a defect or limitation with in Oracle. Schema names cannot have the same name as tables, views, functions or procedures.

Environment

Oracle 10,11

Resolving The Problem

Rename the schema or stored procedure.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.4.1;8.4;8.3;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21577356

Page Feedback