I have an Oracle Package created that I need to import into FM. The reason for using Oracle Package is this returns data based on user id. I am using this package as the source for my parameter map to filter query subjects in my model.
The package returns varchar2(1000) data type. The query subject doesn't work for all users. FM throws "UDA-SQL-0283 Metadata describing xxx does not match results from the database". When I looked up the error I found that the data type of the data set returned by the Package needs to be the same in all cases.
My package returns varchar2 data type in all cases, but Cognos shows data type as character length 16 with a precision and size value. The precision and size value differ when I import the package as different users.
Is there any way to avoid the precision and size values or get it to be set the same?