Home » Other » Training & Certification » Packages
Packages [message #258732] Mon, 13 August 2007 08:38 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

i need answers for this packages..

coding here:package body

create or replace package body A
is
procedure a1();
--codings here.
end a1;

procedure a2();
--codings here.
end a2;

procedure a3();
--codings here.
end a3;
end A;

I facing an error in procedure a3() in compile time.How can i rectify this error in this package..How can i compile procedure a3() only.

Anybody help me please..

Regards,
Arunkumar


[Updated on: Mon, 13 August 2007 08:38]

Report message to a moderator

Re: Packages [message #258733 is a reply to message #258732] Mon, 13 August 2007 08:42 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Solution :

Fix the errors in the code.

Since you didn't give us any code or any error messages, that's about all I can tell you.
Re: Packages [message #258735 is a reply to message #258732] Mon, 13 August 2007 08:45 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear Thomas,

OK.I accept Your reply.This is interview question.one person ask to me..

So just..expecting your replies..
Re: Packages [message #258741 is a reply to message #258735] Mon, 13 August 2007 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For interview question, post in "Homework, training & certification" forum.

Regards
Michel
Re: Packages [message #258743 is a reply to message #258735] Mon, 13 August 2007 09:00 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, there are a couple of options in this case.

What I would do is :

- Read the Error Message ( Where the line where the error happened should be included )
- Have a look at that line in the code to see what's there and try to figure out why the error happened.
- Fix the error and re-compile the package.

But things like that are best learned by doing them, not by memorizing answers, I must confess. The interviewer is most likely able to tell wether you really have done it, or just memorized the answer.
Re: Packages [message #258800 is a reply to message #258743] Mon, 13 August 2007 10:50 Go to previous messageGo to next message
Habeeb
Messages: 61
Registered: August 2000
Member
SQL> create or replace package a as
  2    global_val varchar2(10);
  3  end;
  4  /

Package created.

SQL> create or replace package body A
  2  is
  3  procedure a1 as
  4  begin
  5    null;
  6  end a1;
  7  procedure a2 as
  8  begin
  9    null;
 10  end a2;
 11  procedure a3 as
 12  begin
 13    null;
 14  end a3;
 15  end a;
 16  /

Package body created.

Re: Packages [message #258876 is a reply to message #258732] Mon, 13 August 2007 12:40 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
akkumar81 wrote on Mon, 13 August 2007 15:38

I facing an error in procedure a3() in compile time.How can i rectify this error in this package..How can i compile procedure a3() only.


You can not compile a single procedure in a package.

For someone who has shown quite a gap in your Oracle knowledge over the past time, you seem to have a lot of interviews...
Or maybe you are just kidding us?
Re: Packages [message #259129 is a reply to message #258876] Tue, 14 August 2007 08:43 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Frank wrote on Mon, 13 August 2007 13:40

For someone who has shown quite a gap in your Oracle knowledge over the past time, you seem to have a lot of interviews...
Or maybe you are just kidding us?


That's because he is thrown out of every interview on the first question based on the inept answer given.
Previous Topic: Cursors
Next Topic: Hoy to update a column of table A with data from column of table B?
Goto Forum:
  


Current Time: Fri Apr 26 17:51:56 CDT 2024