Yes, what you’re interested in is a function that returns piped row output.
The usage would be something like:
Select * from table(my_function(variable_1, variable_2));
Then whatever you’ve specified in your function and whatever data you’re choosing to pipe through it, will be displayed in a table.
On Nov 6, 2013, at 1:03 PM, “Eduardo Azevedo” email@example.com wrote:
Thread created by Eduardo Azevedo
In Oracle is possible create a Procedure that return is a table ?
CREATE OR REPLACE PROCEDURE TESTE
NOME IN VARCHAR,
NEMPRESTIMO OUT INTEGER,
NAGENCIA OUT VARCHAR,
QUANTIA OUT NUMBER
WHERE NOME_AGENCIA = NOME;
I tried a most forms, but i could not.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Oracle notifications altogether.
Toad World - Oracle Discussion Forum
Flag this post as spam/abuse.