Select No returns data from inside the procedure

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc

Poston Fri, 22 Nov 2013 8:16 am

Guys, I have a select simpl. from inside the procedure I execute a select * from all_tab_columns and he doesn't return anything. When I execute the same select isolated outside the procedure he returns the data.

someone's got a problem with this?

Poston Fri, 22 Nov 2013 4:20 pm

Brother, there's something wrong in the parameters of your procedure.
Location: Brasília

Adriano Alves
---Para cada problema dificil existe uma solução simples.----

Poston Wed, 27 Nov 2013 6:34 pm

@cleberz, post here the code of procedure so we can help you. Until the 11 g, select to return data in a procedure you need to create an output parameter of type sys_refcursor, you did that?

[] s
Location: São Paulo - SP

Fábio Prado

Poston Thu, 28 Nov 2013 8:49 am

I believe that it can be problem of grant, owner for execution of the procedure.
Have you checked that? If the procedure is an owner different from what you run the select manually?
Location: Fortaleza - CE


Daniel N.N.

  • See also
    Last Post

Return to PL/SQL

Who is online

Users browsing this forum: Google Adsense [Bot] and 8 guests