Home » SQL & PL/SQL » SQL & PL/SQL » Package
Package [message #225826] Wed, 21 March 2007 11:16 Go to next message
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

I created a package named pack

Create Or Replace Package pack Is
Type reff Is Ref Cursor;
Type emprec Is Record(ENAME Varchar2(100),DNAME Varchar2100));
Cursor C Return emprec;
SQL> /

Package created.

Create Or Replace Package Body pack Is
Cursor C Return emprec Is

Package body created.

Now please tell me how to use Cursor C in PL/SQL Block or in Procedure
Re: Package [message #225862 is a reply to message #225826] Wed, 21 March 2007 15:00 Go to previous messageGo to next message
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Read the oracle documentation.
Re: Package [message #225988 is a reply to message #225826] Thu, 22 March 2007 03:34 Go to previous messageGo to next message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Show us what you've tried and we'll fix it, or failing that, read some of the online documentation, which can be found easily from the sticky post at the top of this forum
Re: Package [message #226826 is a reply to message #225988] Mon, 26 March 2007 13:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Reported By: getritesh On: Mon, 26 March 2007 13:59 In: SQL & PL/SQL SQL & PL/SQL Newbies Package
Reason I am not satisfied by answer given to my query,please please give me the perfect answer

Could you Define what you mean by "perfect answer"?

Re: Package [message #226928 is a reply to message #226826] Mon, 26 March 2007 23:46 Go to previous messageGo to next message
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi getritesh,

dude there is no point in reporting to the moderator for getting a "perfect" answer..

all you have to do is to try yourself and post the code or the error messages if any. once if u start trying,there are lot of people here to help you in solving the problem .. but no one does the home work for you..

and you dont pay people here for doing your work

and the documentation given by all the people above will help you in creating the cursor and using them

instead reporting for not getting the answer you desired will never lead you to any thing...

Re: Package [message #226944 is a reply to message #225862] Tue, 27 March 2007 00:20 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
S.Rajaram wrote on Wed, 21 March 2007 21:00
Read the oracle documentation.

This IS the perfect answer.
Previous Topic: Urgent: creating a record in RAC
Next Topic: Problem: ORA-00980: synonym translation is no longer valid
Goto Forum:

Current Time: Wed Aug 23 12:44:47 CDT 2017

Total time taken to generate the page: 0.05759 seconds