OraFAQ Forum: SQL & PL/SQL » what is the difference between "REF CURSOR" AND "SYS

Home » SQL & PL/SQL » SQL & PL/SQL » what is the difference between "REF CURSOR" AND "SYS_REFCUSOR"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304427]

Wed, 05 March 2008 03:02

lzfhope
Messages: 69
Registered: July 2006

Member

hi,
PL/SQL REF CURSOR TYPE can be strong type and weak Type.
I declare ref cursor type var in two ways:
1) Type t_ref is REF CURSOR return ...;
Vday t_ref;
2) Vday Sys_refcusor;
Up to now,the var will work well.
But ,i want to know the difference.

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304430 is a reply to message #304427]

Wed, 05 March 2008 03:12

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Answer is direclty in the documentation so it is not an expert question.

Regards
Michel

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304434 is a reply to message #304427]

Wed, 05 March 2008 03:32

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

[MC: Removed copyrighted extract from Steven Feuerstein's book "Oracle PL/SQL LanguagePocket Reference".]

regards,

[Updated on: Wed, 05 March 2008 04:04] by Moderator

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304436 is a reply to message #304434]

Wed, 05 March 2008 03:40

lzfhope
Messages: 69
Registered: July 2006

Member

thank you very much!

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304440 is a reply to message #304434]

Wed, 05 March 2008 03:59

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

@mshrkshl

When you quote a document or someone else, at least say you quote it or better post a link to it.
Don't steal other work.

Regards
Michel

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304453 is a reply to message #304427]

Wed, 05 March 2008 05:05

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

ok.

thanks and regards,

[Updated on: Wed, 05 March 2008 05:22]

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304462 is a reply to message #304427]

Wed, 05 March 2008 05:22

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

Ref Cursor:
type r is ref cursor;
r1 r;

Sys ref cursor;
r sys_refcursor;

Thanks
Mano

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304479 is a reply to message #304462]

Wed, 05 March 2008 06:23

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Hmm, pretty good explaination.
You remind me my grand-mother when I was a child and I asked her: "what does "build" mean?" and she answered me: "build is build, build a building for instance".

Regards
Michel

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304507 is a reply to message #304479]

Wed, 05 March 2008 07:36

Frank
Messages: 7901
Registered: March 2000

Senior Member

sounds like your granny wasn't very much into spoonfeeding Smile

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304511 is a reply to message #304507]

Wed, 05 March 2008 07:58

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

After that I asked my father which gave me the dictionary and teached me how to use it... seems to be hereditary. Smile

And now I know how to find the definition of ref cursor and sys_refcursor in PL/SQL guide in a couple of seconds. Smug

Regards
Michel

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304619 is a reply to message #304511]

Wed, 05 March 2008 19:16

lzfhope
Messages: 69
Registered: July 2006

Member

You are funny and humourous men. Thank you again!
Since i am not a industrious people ,but a lazy bone,so i do not want to find the answer in those books,as you know,Oracle provides us with so so many books.I beleive that you are reliable experts and would get the corrent answer.
I hope i would change what i have hone!
Laughing

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304648 is a reply to message #304619]

Thu, 06 March 2008 00:39

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Here's a useful link: Oracle Search Documentation

You will get answer to your questions in few seconds with it.

Regards
Michel

Report message to a moderator

Previous Topic:	Does order by slow down searches
Next Topic:	[HELP] SQL complex query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 16:35:29 CST 2025