Link Table and Ref Cursor Table

[fragolita]

Hi all!!
How can I link Table and Ref Cursor Table??
I mean, How can I pass input parameters to the PL/SQL procedure if they are not User parameters but they come from another table??
Thanks a lot
F.

 

[nagornyi]

Using Link tool from the toolbar, create the link between the regular query group having the fields you need, and the header of the Ref Cursor query. Again, this would be not the regular field-to-field link, but rather group-to-query link. Then you will be able to use the fields in the procedure call by preceding their names with the colon.

 

[fragolita]

Thanks a lot ...