Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link Table and Ref Cursor Table

Status
Not open for further replies.

fragolita

Programmer
Aug 22, 2006
11
IT
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top