CURSOR_TYPE -- what is this?

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
royjaydAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.