OraFAQ Forum: SQL & PL/SQL » Package & Procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Package & Procedure

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

Package & Procedure [message #560846]

Tue, 17 July 2012 07:20

satheesh_ss
Messages: 54
Registered: July 2012

Member

In package specification, there 3 procedures
But in package body, there are 2 procedures...will this execute?

Report message to a moderator

Re: Package & Procedure [message #560848 is a reply to message #560846]

Tue, 17 July 2012 07:26

Littlefoot
Messages: 17227
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try, and you'll know for sure.

Report message to a moderator

Re: Package & Procedure [message #560857 is a reply to message #560846]

Tue, 17 July 2012 07:58

joy_division
Messages: 4285
Registered: February 2005
Location: East Coast USA

Senior Member

We're a little tired of these questions. Why don't you read a book or try things yourself. Is how you do things at your job also? So sad.

Report message to a moderator

Re: Package & Procedure [message #560862 is a reply to message #560846]

Tue, 17 July 2012 08:04

Michel Cadot
Messages: 54652
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Tue, 17 July 2012 11:43

Michel Cadot wrote on Tue, 17 July 2012 11:36
From your previous topic:

Michel Cadot wrote on Tue, 17 July 2012 11:35
From your previous topic:

Michel Cadot wrote on Sat, 14 July 2012 16:11
None.

From your previous topics:

Michel Cadot wrote on Thu, 12 July 2012 19:52
...
You not only have to read the Concepts manual but also the Database SQL Reference.

Regards
Michel

Michel Cadot wrote on Thu, 12 July 2012 15:11
From your previous topic:

Michel Cadot wrote on Thu, 12 July 2012 14:08
Please feedback to your previous topics and thanks people that (try to) help you.
Also from your previous topics:

Michel Cadot wrote on Thu, 12 July 2012 08:39
All your questions are answered in Database Concepts.
Please read it.

Regards
Michel

Michel Cadot wrote on Thu, 12 July 2012 08:47
...
Database Concepts

Regards
Michel

Regards
Michel

In addition, this is a FAQ already posted a hundred time, so SEARCH before posting (accordingly to the guide).

Regards
Michel

What is your problem in writing this?
With any SQL question, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Use SQL*Plus and copy and paste what you already tried.

Regards
Michel

...

Report message to a moderator

Re: Package & Procedure [message #560866 is a reply to message #560862]

Tue, 17 July 2012 08:30

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

@satheesh_ss,reply the micheal comments.. Please don't post this type question...it's interview question...

Report message to a moderator

Re: Package & Procedure [message #560872 is a reply to message #560866]

Tue, 17 July 2012 08:57

Michel Cadot
Messages: 54652
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, post this question but first post what you think and tried and don't forget to feedback and thank.

Regards
Michel

Report message to a moderator

Re: Package & Procedure [message #560959 is a reply to message #560872]

Wed, 18 July 2012 00:36

satheesh_ss
Messages: 54
Registered: July 2012

Member

Kind request to all the members of this forum community.....I m not a employee in any company....I m a student who is learning SQL & PLSQL for the past few days....The questions i m asking is not an ordinary question of my own..Its an interview questions....So If anyone dont want to answer my question thn just leave away and carry on your work...Let others answer my question if they are interested.....But remember Onething.....You may be brilliant now...But u too in the same stage just like me at your beginning...Thanks.

Report message to a moderator

Re: Package & Procedure [message #560961 is a reply to message #560959]

Wed, 18 July 2012 00:44

Michel Cadot
Messages: 54652
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Kind request to all students of this community..... I have never broken the rules of the places I have been..... and I have always thanked those that helped me..... even when I was learning, so being a student is not an excuse for bad behaviour..... So read and follow the guide or..... as you said..... "just leave away"...... Thanks.

Regards
Michel

Report message to a moderator

Re: Package & Procedure [message #560965 is a reply to message #560961]

Wed, 18 July 2012 00:51

Littlefoot
Messages: 17227
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There are questions that would require some "knowledge" which you'd gather by lots of reading & researching and - if you don't know the keyword to search for, it might take ages before you find the answer. Therefore, you ask for help - no problem with that.

On the other hand, there are questions like the one you posted here which require not more than several minutes to write a dummy package specification and its body and see what happens. Not even trying to find that kind of an answer has no excuse, so I refuse to answer that. You might find someone nicer than me who will spoonfeed you.

Report message to a moderator

Re: Package & Procedure [message #560966 is a reply to message #560961]

Wed, 18 July 2012 00:53

satheesh_ss
Messages: 54
Registered: July 2012

Member

Dear Mr.Michel, i think its not a place for debate.....I m just asking you all to answer my question with request....Being a student i cant be a profession all of a sudden......So i m just asking the interview questions...Let our forum community keep helping others....Be Cool Mr.Michel.

Report message to a moderator

Re: Package & Procedure [message #560968 is a reply to message #560966]

Wed, 18 July 2012 01:07

Michel Cadot
Messages: 54652
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Dear satheesh_ss, i think its not a place for debate.....I m just asking you to follow the guide and have a fair behaviour..... Being a student is not an excuse to not read and follow the guide and read the books we pointed you too many times......So i m just asking you first search the answer to the interview questions.....Be Cool Mr.satheesh_ss.

Report message to a moderator

Re: Package & Procedure [message #560972 is a reply to message #560968]

Wed, 18 July 2012 01:14

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Hey Guys...
@satheesh_ss,per your comments it will raise the below error. Find the below example...

CREATE or replace PACKAGE package_name AS
 
       FUNCTION fun1(p_arg IN INTEGER) RETURN INTEGER;
  
       FUNCTION fun2 ( p_parameter IN INTEGER ) RETURN INTEGER;
       
       FUNCTION fun3 ( p_parameter IN INTEGER ) RETURN INTEGER;       
 
   END package_name;
/

CREATE or replace PACKAGE BODY package_name AS
  
       FUNCTION fun1(
               p_arg IN INTEGER
                ) RETURN INTEGER IS
       BEGIN
          RETURN p_arg;
       END fun1;
  
      FUNCTION fun2(
               p_parameter IN INTEGER
               ) RETURN INTEGER IS
      BEGIN
         RETURN -p_parameter;
      END fun2;
 
   END package_name;
 /

Check the below error..

PLS-00323: subprogram or cursor 'FUN3' is declared in a package specification and must be defined in the package body

Let me your feedback...
Thanks,

Report message to a moderator

Re: Package & Procedure [message #560993 is a reply to message #560966]

Wed, 18 July 2012 03:17

arif_md2009
Messages: 678
Registered: May 2009
Location: United Arab Emirates

Senior Member

Dear Sateesh_ss , its very simple to follow the forum guidelines, and whatever advice these people give you they give it you from their experiences and i was also one of the memeber who benefitted a lot out of this forum, whether its Michel or Barbara or littlefoot or Muralikri and many others they all have helped me lot in learning new things which also increased prodcutivity in my work place.So my sincere advice to you is just keep on learning by refernces to books which michel provided instead of jumping on interview questions directly.

Report message to a moderator