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..?
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.