Home » SQL & PL/SQL » SQL & PL/SQL » Package & Procedure
Package & Procedure [message #560846] Tue, 17 July 2012 07:20 Go to next message
satheesh_ss
Messages: 61
Registered: July 2012
Member
In package specification, there 3 procedures
But in package body, there are 2 procedures...will this execute?
Re: Package & Procedure [message #560848 is a reply to message #560846] Tue, 17 July 2012 07:26 Go to previous messageGo to next message
Littlefoot
Messages: 19893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try, and you'll know for sure.
Re: Package & Procedure [message #560857 is a reply to message #560846] Tue, 17 July 2012 07:58 Go to previous messageGo to next message
joy_division
Messages: 4559
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.
Re: Package & Procedure [message #560862 is a reply to message #560846] Tue, 17 July 2012 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
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


...

Re: Package & Procedure [message #560866 is a reply to message #560862] Tue, 17 July 2012 08:30 Go to previous messageGo to next message
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...
Re: Package & Procedure [message #560872 is a reply to message #560866] Tue, 17 July 2012 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
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
Re: Package & Procedure [message #560959 is a reply to message #560872] Wed, 18 July 2012 00:36 Go to previous messageGo to next message
satheesh_ss
Messages: 61
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.
Re: Package & Procedure [message #560961 is a reply to message #560959] Wed, 18 July 2012 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
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
Re: Package & Procedure [message #560965 is a reply to message #560961] Wed, 18 July 2012 00:51 Go to previous messageGo to next message
Littlefoot
Messages: 19893
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.
Re: Package & Procedure [message #560966 is a reply to message #560961] Wed, 18 July 2012 00:53 Go to previous messageGo to next message
satheesh_ss
Messages: 61
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.
Re: Package & Procedure [message #560968 is a reply to message #560966] Wed, 18 July 2012 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
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.
Re: Package & Procedure [message #560972 is a reply to message #560968] Wed, 18 July 2012 01:14 Go to previous messageGo to next message
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,
Re: Package & Procedure [message #560993 is a reply to message #560966] Wed, 18 July 2012 03:17 Go to previous messageGo to next message
arif_md2009
Messages: 732
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.
Re: Package & Procedure [message #560999 is a reply to message #560993] Wed, 18 July 2012 03:44 Go to previous messageGo to next message
satheesh_ss
Messages: 61
Registered: July 2012
Member
Thanks for your Kind advice Mr.arif md2009....I will follow for sure....Thanks.
Re: Package & Procedure [message #561000 is a reply to message #560972] Wed, 18 July 2012 03:48 Go to previous message
satheesh_ss
Messages: 61
Registered: July 2012
Member
I am too getting the same error mr.muralikar....Hmmmm,Thanks for your answer.
Previous Topic: concurrency with ORA_ROWSCN
Next Topic: Rownum
Goto Forum:
  


Current Time: Mon Dec 22 12:45:29 CST 2014

Total time taken to generate the page: 0.06020 seconds