Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

CURSOR_TYPE -- what is this?

Posted on 2013-01-25
1
Medium Priority
?
302 Views
Last Modified: 2013-02-11
hi guys

I have my store procedure in oracle 11g

PROCEDURE CUSTOMER_SEARCH(results_cursor IN OUT CURSOR_TYPE
,status  in CUSTOMER.STATUS%Type                                   
    )
    AS
    sQuery VARCHAR2(5000);
    BEGIN
...

I want to know what does CURSOR_TYPE mean ?

thanks
0
Comment
Question by:royjayd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1300 total points
ID: 38819832
if this is part of a package, you may find the definition of that type inside the package spec.
otherwise, you can check up the "TYPES" in your database to find it.
it will likely by a REF CURSOR, see this page for example:_
http://psoug.org/reference/ref_cursors.html
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question