%ROWTYPE support?

[jcanada-gl]

I have a case where I have to call a function that has an "out" parameter of type ROWTYPE. Is there any way to get that type of data? Is there any chance that RegisterType works? I am currently using sqlx, and I think it is not compatible.

[sijms]

I think I should test and see what oracle return for this datatype then update the code
would you send an example code to test it

[jcanada-gl]

Yes, give me some time.

[jcanada-gl]

Ok, so if you take THIS example, and replace the sqlText from de function createStoredProc for this one:
CREATE OR REPLACE PROCEDURE GOORA_TEMP_GET_VISIT ( LVISIT_ID IN NUMBER, OUT_VISIT OUT GOORA_TEMP_VISIT%ROWTYPE ) AS BEGIN SELECT * INTO OUT_VISIT FROM GOORA_TEMP_VISIT WHERE VISIT_ID = LVISIT_ID; END GOORA_TEMP_GET_VISIT;
should do the trick at oracle level.

Let me know if this is what you where expecting.

How can you see what oracle it's returning?

[sijms]

sorry for late replay
I think procedure like this should be used inside pl/sql statement (BEGIN... END) because you should pass valid type for out_visit when calling the procedure/function otherwise oracle will return error

[sijms]

another solution is to create custom type (user define type) object with same fields as table and pass it to the function