Placing a Select statement into a PL/SQL procedure and calling it from BIP
Hey All
I have a piece of SQL that I would like to put into a PL/SQL procedure and call, as I have done in the past with MS T-SQL querys.
I have been doing a bit of researching around this and found the following posts:
https://forums.oracle.com/forums/thread.jspa?messageID=10318844�
Which I have looked at, and got a bit confused as I am new to Oracle PL/SQL
Could someone explain to me using the example of this simple select statement, what I need to do to create a "pipelined function" to be able to call this from the data model in BI publisher?
I have a piece of SQL that I would like to put into a PL/SQL procedure and call, as I have done in the past with MS T-SQL querys.
I have been doing a bit of researching around this and found the following posts:
https://forums.oracle.com/forums/thread.jspa?messageID=10318844�
Which I have looked at, and got a bit confused as I am new to Oracle PL/SQL
Could someone explain to me using the example of this simple select statement, what I need to do to create a "pipelined function" to be able to call this from the data model in BI publisher?
0