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?

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] ... +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.
Location: Araraquara - SP


OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional

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: ... 5f1736f02b
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. ... tions.html

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

  • See also
    Last Post

      Return to PL/SQL

      Who is online

      Users browsing this forum: No registered users and 2 guests