Get the return of a function in sql plus which is a cursor

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 Wed, 25 Mar 2009 7:34 pm

Guys, how do I do an anonymous block to test a function that returns a cursor?

abs
Mesquita
Location: rj

Poston Wed, 25 Mar 2009 8:34 pm

Say brother, beleza?

Take a look at this example below, which returns an object (PL/SQL Table).
[url = http//www : . glufke . net/oracle/viewtopic php? t = 4408 . & highlight = pl + sql + table] http://www.glufke.net/oracle/viewtopic. ... +sql+table [/url] do a little research on his own forum for REF CURSOR which also can aid in interpretation.

Anything, send it to us.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Thu, 26 Mar 2009 9:39 am

I think the answer to this topic meets what you need, apart from the package with the declarations of type of the cursor the other procedures can be anonymous blocks: http://glufke.net/oracle/viewtopic.php? ... 5f1736f02b
fsitja
Location: Gaúcho no Rio de Janeiro - RJ

"The scars exist to remind us that the past was real"
Campanha: Como fazer uma pergunta e obter uma resposta.
http://tkyte.blogspot.com/2005/06/how-t ... tions.html

OCA & OCP Developer — OCE SQL Expert — OCS Data Warehousing Specialist


  • See also
    Replies
    Views
    Last Post


      Return to PL/SQL

      Who is online

      Users browsing this forum: No registered users and 2 guests