Steve, i'll try to clarify.
>>but the issue is not in the designer, the VDB schema ( conencting using jdbc) does not include the procedure. I think it should.
>Teiid does not inject the source metadata unless a dynamic vdb is used.
OK, i didn't know that. I did use a dynamic vdb and got the same problem. but i'll re-check if i'm screwing something up.
Let me check if I understood correctly:
I should:
1) create a source model from an sqlserver database and include only one table.
2) add a procedure called "native" to that source model, that receives a string as parameter and returns a one column result set typed object.
3)create a View model that executes the native procedure i defined in point 2.
once i deploy the vdb expected results would be:
4) if a query the view defined in point 3, it should work
5) if a browse the vdb schema i should see the native procedure I created in the source model.
6) if I run the native procedure by itself, not using the defined view, should it work?
>> by the way, i added the procedure in the designer and it throws "native" does not exist when a run a view. that makes sense because native is not define in the vdb metadata witch is the issue.
>Can you elaborate more here? If you added the procedure it shouldn't say that it doesn't exist.
Sorry i wasn't clear. what i meant was that i defined the procedure in the source model, i could use it with no problems in the designer, but when i deployed de vdb and queried the view that called my native procedure. I got a "native does not exists" error.
I'll try it again, maybe a did something wrong.
please confirm that my example above is the right way to go.
Thank you very much for your help.
