Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    25

    Unanswered: Join clause with resultset return by procedure in oracle

    I need to used resultset return by one store procedure which is in term being called in another procedure, in Join clause. Means if Demo is one store procedure which is called by Demo2 procedure and Demo procedure returns one resultset which i need to used in join clause in Demo2 procedure and finaly i need to return resultset from Demo store procedure.. Is there any solution to have scenario like this..?

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    If this is not just a part of an implementation, which could be solved more efficiently overall (e.g. using simple SELECT statement without building intermediate resultset at all), I would consider using pipelined function.

    You may find example of its usage e.g. in this article: http://www.oracle-base.com/articles/...able_functions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •