ODS View Association problem

[NizarKaouri]

Hello everyone,

i am working with a model of Open ODS Views based on SQL Views. Right now i am facing 2 issues that i can't figure out a solution for:

Issue 1:

I have a SQL View that has 4 Fields: 2 ID Fields and 2 Text Fields. Each ID has it's Text field.
When i consume the SQL View in the ODS View and then in the Composite Provider. I am only able to get the text of the first ID.
I don't even know if this is possible but i tried to associated the ODS View with itself to get the other text. But it didn't work either.

  Issue 2:

I have a INTEGER Field in a SQL View. When i consume it in the ODS View as a CHAR(11) and associate it with oder ODS View. I get the error that: invalid number: not a valid number string '"'.
This is because the Database cannot convert the NULL or empty values to Strings. As a work around i replace all the Null values with -1.
Is there a better Solution than this?

Thank you for your time