Resolution:
Description
============
Using user "user1" to create the object type and procedure.

create or replace type TYPE1 AS OBJECT (
  ID           NUMBER,
  TS           DATE
)/

create or replace PROCEDURE sp
(
    IN_TYPE IN TYPE1,
    O_ERROR_CODE       OUT NUMBER,                
    O_ERROR_MESSAGE    OUT VARCHAR2
) IS
BEGIN
O_ERROR_CODE:=123;
O_ERROR_MESSAGE:='error message';
END sp;

Using Oracle thin driver ojdbc6.jar in the BW classpath. Logging in to BW JDBC connection using user "user2". The test connection works. When the procedure is loaded, the attribute of the object type (ID, TS) does not display.

Environment
===========
BW 5.8 and above
Oracle 10g or 11g

Resolution
==========
The problem is caused by insufficient permissions of user2. The type and procedure are created in schema "user1". user2 needs to have privileges on the type and procedure. To grant privileges to user2, run the following commands:

grant execute on user1.sp to user2;
grant execute on user1.TYPE1 to user2;

Oracle procedure has an input parameter of object type(ID, TS). JDBC Call Procedure does notshow attributes of the object type in Input tab. type.