|
|
|
|
|
|
| Author |
Message |
Wallace
*nix forums beginner
Joined: 19 Apr 2005
Posts: 20
|
 Posted: Thu May 25, 2006 1:26 pm Post subject:
Help!!
|
|
|
Hai All,
I am new to oracle.
I created a package with one function, as follows
SPEC:
---------
create or replace PACKAGE "PACKAGE_MAIN" AS
FUNCTION "TEST"
(Empid NUMBER) RETURN INTEGER;
END;
BODY:
----------
create or replace PACKAGE BODY "PACKAGE_MAIN" AS
FUNCTION "TEST"
(Empid NUMBER)
RETURN INTEGER AS
--performing a select using empid in where clause
END;
My question is "How to give value for that empid?"
Looking forward for the response...
Thanx in advance... |
|
| Back to top |
|
 |
Sybrand Bakker
*nix forums Guru
Joined: 03 Apr 2005
Posts: 1766
|
| Posted: Thu May 25, 2006 2:34 pm Post subject:
Re: Help!!
|
|
|
On 25 May 2006 06:26:13 -0700, "Wallace"
<princevictor.moses@gmail.com> wrote:
| Quote: | Hai All,
I am new to oracle.
I created a package with one function, as follows
SPEC:
---------
create or replace PACKAGE "PACKAGE_MAIN" AS
FUNCTION "TEST"
(Empid NUMBER) RETURN INTEGER;
END;
BODY:
----------
create or replace PACKAGE BODY "PACKAGE_MAIN" AS
FUNCTION "TEST"
(Empid NUMBER)
RETURN INTEGER AS
--performing a select using empid in where clause
END;
My question is "How to give value for that empid?"
Looking forward for the response...
Thanx in advance...
|
Just like an ordinary parameter in an ordinary 3GL programming
language, as demonstrated in the PL/SQL reference manual.
Does the IQ of developers dwindly that rapidly, or are you just an
exceptional case?
--
Sybrand Bakker, Senior Oracle DBA |
|
| Back to top |
|
|
Laurenz Albe
*nix forums Guru
Joined: 21 Feb 2005
Posts: 478
|
| Posted: Fri May 26, 2006 8:15 am Post subject:
Re: Help!!
|
|
|
Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
| Quote: | On 25 May 2006 06:26:13 -0700, "Wallace"> <princevictor.moses@gmail.com
wrote:
|
[an admittedly silly question]
| Quote: | Just like an ordinary parameter in an ordinary 3GL programming
language, as demonstrated in the PL/SQL reference manual.
Does the IQ of developers dwindly that rapidly, or are you just an
exceptional case?
--
Sybrand Bakker, Senior Oracle DBA
|
While I do not dispute that the original question was astoundingly trivial,
please think twice before you reply in such a rude manner.
Remember, you do not have to reply to postings that you perceive as
silly or irrelevant. Giving no answer is also an answer, and in a case
like that maybe the best.
The general tone on Usenet has already become so much more rude than it
used to be, there's no need to add to that.
Yours,
Laurenz Albe |
|
| Back to top |
|
|
GuessWho
*nix forums beginner
Joined: 29 Jun 2006
Posts: 10
|
| Posted: Thu Jun 29, 2006 11:42 am Post subject:
Re: Help!!
|
|
|
I agree. I haven't been on this newsgroup for some years, but immediately
saw the familiar Sybrand Bakker replies, like he's been doing for years now.
I suggest he creates his own comp.databases.oracle.SybrandBakker group......
Some questions are trivial, but if they are, the answers are too in most
cases.
It's not only people in this newsgroup he's frustrating. It seems to be a
hobby of his. For those who can read Dutch read this:
| Quote: | Onzin, er bestaan wel degelijk gemodereerde nieuwsgroepen. Dankzij het
feit dat de meeste nederlandse niet gemodereerd zijn, kunnen eikels
zoals jij hier nog altijd hun uitwerpselen in kwijt.
Sybrand Bakker
|
Would he know that *comp* does mean *comp*uter, not *comp*lain ?
"Laurenz Albe" <invite@spam.to.invalid> wrote in message
news:1148631356.514091@proxy.dienste.wien.at...
| Quote: | Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
On 25 May 2006 06:26:13 -0700, "Wallace"> <princevictor.moses@gmail.com
wrote:
[an admittedly silly question]
Just like an ordinary parameter in an ordinary 3GL programming
language, as demonstrated in the PL/SQL reference manual.
Does the IQ of developers dwindly that rapidly, or are you just an
exceptional case?
--
Sybrand Bakker, Senior Oracle DBA
While I do not dispute that the original question was astoundingly
trivial,
please think twice before you reply in such a rude manner.
Remember, you do not have to reply to postings that you perceive as
silly or irrelevant. Giving no answer is also an answer, and in a case
like that maybe the best.
The general tone on Usenet has already become so much more rude than it
used to be, there's no need to add to that.
Yours,
Laurenz Albe |
|
|
| Back to top |
|
|
gazzag
*nix forums Guru Wannabe
Joined: 08 Jun 2005
Posts: 277
|
| Posted: Thu Jun 29, 2006 12:12 pm Post subject:
Re: Help!!
|
|
|
GuessWho wrote:
| Quote: | I agree. I haven't been on this newsgroup for some years, but immediately
saw the familiar Sybrand Bakker replies, like he's been doing for years now.
I suggest he creates his own comp.databases.oracle.SybrandBakker group......
Some questions are trivial, but if they are, the answers are too in most
cases.
It's not only people in this newsgroup he's frustrating. It seems to be a
hobby of his. For those who can read Dutch read this:
Onzin, er bestaan wel degelijk gemodereerde nieuwsgroepen. Dankzij het
feit dat de meeste nederlandse niet gemodereerd zijn, kunnen eikels
zoals jij hier nog altijd hun uitwerpselen in kwijt.
Sybrand Bakker
Would he know that *comp* does mean *comp*uter, not *comp*lain ?
"Laurenz Albe" <invite@spam.to.invalid> wrote in message
news:1148631356.514091@proxy.dienste.wien.at...
Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
On 25 May 2006 06:26:13 -0700, "Wallace"> <princevictor.moses@gmail.com
wrote:
[an admittedly silly question]
Just like an ordinary parameter in an ordinary 3GL programming
language, as demonstrated in the PL/SQL reference manual.
Does the IQ of developers dwindly that rapidly, or are you just an
exceptional case?
--
Sybrand Bakker, Senior Oracle DBA
While I do not dispute that the original question was astoundingly
trivial,
please think twice before you reply in such a rude manner.
Remember, you do not have to reply to postings that you perceive as
silly or irrelevant. Giving no answer is also an answer, and in a case
like that maybe the best.
The general tone on Usenet has already become so much more rude than it
used to be, there's no need to add to that.
Yours,
Laurenz Albe
|
Please do not top-post.
*ducks and covers*
;) |
|
| Back to top |
|
|
psoug
*nix forums Guru
Joined: 15 May 2005
Posts: 3492
|
| Posted: Thu Jun 29, 2006 3:36 pm Post subject:
Re: Help!!
|
|
|
GuessWho wrote:
| Quote: | I agree. I haven't been on this newsgroup for some years, but immediately
saw the familiar Sybrand Bakker replies, like he's been doing for years now.
I suggest he creates his own comp.databases.oracle.SybrandBakker group......
Some questions are trivial, but if they are, the answers are too in most
cases.
It's not only people in this newsgroup he's frustrating. It seems to be a
hobby of his. For those who can read Dutch read this:
Onzin, er bestaan wel degelijk gemodereerde nieuwsgroepen. Dankzij het
feit dat de meeste nederlandse niet gemodereerd zijn, kunnen eikels
zoals jij hier nog altijd hun uitwerpselen in kwijt.
Sybrand Bakker
Would he know that *comp* does mean *comp*uter, not *comp*lain ?
"Laurenz Albe" <invite@spam.to.invalid> wrote in message
news:1148631356.514091@proxy.dienste.wien.at...
Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
On 25 May 2006 06:26:13 -0700, "Wallace"> <princevictor.moses@gmail.com
wrote:
[an admittedly silly question]
Just like an ordinary parameter in an ordinary 3GL programming
language, as demonstrated in the PL/SQL reference manual.
Does the IQ of developers dwindly that rapidly, or are you just an
exceptional case?
--
Sybrand Bakker, Senior Oracle DBA
While I do not dispute that the original question was astoundingly
trivial,
please think twice before you reply in such a rude manner.
Remember, you do not have to reply to postings that you perceive as
silly or irrelevant. Giving no answer is also an answer, and in a case
like that maybe the best.
The general tone on Usenet has already become so much more rude than it
used to be, there's no need to add to that.
Yours,
Laurenz Albe
|
Thank you for expressing your opinion. We will give it all of the
consideration it is worth.
That said ... perhaps you would remember that top posting is not
appreciated.
Yeah I haven't changed much either. ;-)
Thank you.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org |
|
| Back to top |
|
|
GuessWho
*nix forums beginner
Joined: 29 Jun 2006
Posts: 10
|
| Posted: Mon Jul 03, 2006 9:48 am Post subject:
Re: Help!!
|
|
|
"DA Morgan" <damorgan@psoug.org> wrote in message
news:1151595369.883380@bubbleator.drizzle.com...
| Quote: | GuessWho wrote:
I agree. I haven't been on this newsgroup for some years, but
immediately
saw the familiar Sybrand Bakker replies, like he's been doing for years
now.
I suggest he creates his own comp.databases.oracle.SybrandBakker
group......
Some questions are trivial, but if they are, the answers are too in most
cases.
It's not only people in this newsgroup he's frustrating. It seems to be
a
hobby of his. For those who can read Dutch read this:
Onzin, er bestaan wel degelijk gemodereerde nieuwsgroepen. Dankzij het
feit dat de meeste nederlandse niet gemodereerd zijn, kunnen eikels
zoals jij hier nog altijd hun uitwerpselen in kwijt.
Sybrand Bakker
Would he know that *comp* does mean *comp*uter, not *comp*lain ?
"Laurenz Albe" <invite@spam.to.invalid> wrote in message
news:1148631356.514091@proxy.dienste.wien.at...
Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
On 25 May 2006 06:26:13 -0700, "Wallace"
princevictor.moses@gmail.com
wrote:
[an admittedly silly question]
Just like an ordinary parameter in an ordinary 3GL programming
language, as demonstrated in the PL/SQL reference manual.
Does the IQ of developers dwindly that rapidly, or are you just an
exceptional case?
--
Sybrand Bakker, Senior Oracle DBA
While I do not dispute that the original question was astoundingly
trivial,
please think twice before you reply in such a rude manner.
Remember, you do not have to reply to postings that you perceive as
silly or irrelevant. Giving no answer is also an answer, and in a case
like that maybe the best.
The general tone on Usenet has already become so much more rude than it
used to be, there's no need to add to that.
Yours,
Laurenz Albe
Thank you for expressing your opinion. We will give it all of the
consideration it is worth.
That said ... perhaps you would remember that top posting is not
appreciated.
Yeah I haven't changed much either. ;-)
Thank you.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
|
Point taken (top posting). It's weird though that top posting is the default
in my news reader . . . |
|
| Back to top |
|
|
IANAL_Vista
*nix forums Guru Wannabe
Joined: 27 Nov 2005
Posts: 142
|
| Posted: Tue Jul 04, 2006 10:15 pm Post subject:
Re: Help!!
|
|
|
"GuessWho" <nomail@please.com> wrote in
news:44a8e906$0$31640$e4fe514c@news.xs4all.nl:
| Quote: | Point taken (top posting). It's weird though that top posting is the
default in my news reader . . .
|
Are you incapable or unwilling to over ride the default? |
|
| Back to top |
|
|
frank.van.bortel@gmail.co
*nix forums Guru
Joined: 11 Sep 2005
Posts: 832
|
| Posted: Wed Jul 05, 2006 6:55 pm Post subject:
Re: Help!!
|
|
|
ianal Vista schreef:
| Quote: | "GuessWho" <nomail@please.com> wrote in
news:44a8e906$0$31640$e4fe514c@news.xs4all.nl:
Point taken (top posting). It's weird though that top posting is the
default in my news reader . . .
Are you incapable or unwilling to over ride the default?
MS Outlook.... you can guess the rest (after Brian Ferry) |
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up... |
|
| Back to top |
|
|
Paul
*nix forums Guru
Joined: 25 Feb 2005
Posts: 496
|
| Posted: Wed Jul 05, 2006 8:05 pm Post subject:
Re: Help!!
|
|
|
Frank van Bortel <frank.van.bortel@gmail.com> wrote:
| Quote: | Are you incapable or unwilling to over ride the default?
|
It has to default to the top - how can it know where you wish to
respond?
| Quote: | MS Outlook.... you can guess the rest (after Brian Ferry)
|
Arrow keys, PageDown, Ctrl-End....
<shakes head...>
Paul...
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post. |
|
| Back to top |
|
|
GuessWho
*nix forums beginner
Joined: 29 Jun 2006
Posts: 10
|
| Posted: Thu Jul 06, 2006 10:26 am Post subject:
Re: Help!!
|
|
|
"Paul" <paul@see.my.sig.com> wrote in message
news:vp6oa2t9nf20ldavfajfa6phmil7mnle47@4ax.com...
| Quote: |
Frank van Bortel <frank.van.bortel@gmail.com> wrote:
Are you incapable or unwilling to over ride the default?
|
Just lazy I guess, sorry for that, I'm trying to do better..
| Quote: |
It has to default to the top - how can it know where you wish to
respond?
|
Right... ;-(
| Quote: |
MS Outlook.... you can guess the rest (after Brian Ferry)
Arrow keys, PageDown, Ctrl-End....
shakes head...
|
<nodds head>
So, I turned to inline posting. But: can anyone explain why this is such a
big issue? Especially when I read a thread top to bottom I have to scroll
through the text I have read several times by then. And don't tell me just
to read the last message, because people who make a big issue over top
posting are also the ones snapping out parts of the text. But maybe you're
right and I should turn to a different news reader, Outlook is a crime
(after Pink Floyd).
| Quote: |
Paul...
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't
work!").
Thanks.
Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post. |
|
|
| Back to top |
|
|
gazzag
*nix forums Guru Wannabe
Joined: 08 Jun 2005
Posts: 277
|
| Posted: Thu Jul 06, 2006 10:44 am Post subject:
Re: Help!!
|
|
|
GuessWho wrote:
| Quote: | "Paul" <paul@see.my.sig.com> wrote in message
Are you incapable or unwilling to over ride the default?
Just lazy I guess, sorry for that, I'm trying to do better..
It has to default to the top - how can it know where you wish to
respond?
Right... ;-(
MS Outlook.... you can guess the rest (after Brian Ferry)
Arrow keys, PageDown, Ctrl-End....
shakes head...
nodds head
So, I turned to inline posting. But: can anyone explain why this is such a
big issue? Especially when I read a thread top to bottom I have to scroll
through the text I have read several times by then. And don't tell me just
to read the last message, because people who make a big issue over top
posting are also the ones snapping out parts of the text. But maybe you're
right and I should turn to a different news reader, Outlook is a crime
(after Pink Floyd).
|
A. Because it's contrary to the direction we normally read in.
Q. Why is top-posting so bad, then?
A. Top-posting.
Q. What's the biggest problem with readability on the Net?
HTH ;)
-g |
|
| Back to top |
|
|
GuessWho
*nix forums beginner
Joined: 29 Jun 2006
Posts: 10
|
| Posted: Thu Jul 06, 2006 10:49 am Post subject:
Re: Help!!
|
|
|
"gazzag" <gareth@jamms.org> wrote in message
news:1152182664.361502.301130@a14g2000cwb.googlegroups.com...
| Quote: | GuessWho wrote:
"Paul" <paul@see.my.sig.com> wrote in message
Are you incapable or unwilling to over ride the default?
Just lazy I guess, sorry for that, I'm trying to do better..
It has to default to the top - how can it know where you wish to
respond?
Right... ;-(
MS Outlook.... you can guess the rest (after Brian Ferry)
Arrow keys, PageDown, Ctrl-End....
shakes head...
nodds head
So, I turned to inline posting. But: can anyone explain why this is such
a
big issue? Especially when I read a thread top to bottom I have to
scroll
through the text I have read several times by then. And don't tell me
just
to read the last message, because people who make a big issue over top
posting are also the ones snapping out parts of the text. But maybe
you're
right and I should turn to a different news reader, Outlook is a crime
(after Pink Floyd).
A. Because it's contrary to the direction we normally read in.
Q. Why is top-posting so bad, then?
A. Top-posting.
Q. What's the biggest problem with readability on the Net?
You almost got me there!!!!!!!!!!!  |
|
|
| Back to top |
|
|
frank.van.bortel@gmail.co
*nix forums Guru
Joined: 11 Sep 2005
Posts: 832
|
| Posted: Fri Jul 07, 2006 7:31 pm Post subject:
Re: Help!!
|
|
|
GuessWho schreef:
| Quote: | "gazzag" <gareth@jamms.org> wrote in message
A. Because it's contrary to the direction we normally read in.
Q. Why is top-posting so bad, then?
A. Top-posting.
Q. What's the biggest problem with readability on the Net?
You almost got me there!!!!!!!!!!! ;-)
|
Quoting is another problem. Usually one responds with only
the relevant data of the original message - all the rest
is snipped - some people adhere to the cistom of indicating
something actually was
[snipped]
by using the above (or {deletia})
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up... |
|
| Back to top |
|
|
frank.van.bortel@gmail.co
*nix forums Guru
Joined: 11 Sep 2005
Posts: 832
|
| Posted: Sat Jul 08, 2006 12:51 pm Post subject:
Re: Help!!
|
|
|
Frank van Bortel schreef:
| Quote: | is snipped - some people adhere to the cistom of indicating
something actually was
|
Obviously, that should read custom - not cistom.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up... |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Sun Nov 23, 2008 12:25 pm | All times are GMT
|
|
Loans | Loans | Free Advertising | Jorge Bucay | Watch Anime Online
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
