Packages [message #258732] |
Mon, 13 August 2007 08:38  |
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   |
ThomasG
Messages: 3212 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 #258743 is a reply to message #258735] |
Mon, 13 August 2007 09:00   |
ThomasG
Messages: 3212 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   |
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   |
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  |
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.
|
|
|