Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: please help me out...

Re: please help me out...

From: Can Oezdemir <no_at_spam.net>
Date: Sat, 10 May 2003 10:44:39 +0200
Message-ID: <b9ie5h$jpmdq$1@ID-194392.news.dfncis.de>

"Oracle_learner" <grad_ra_at_yahoo.com> schrieb im Newsbeitrag news:4ca14853.0305100038.524bc920_at_posting.google.com...
> hello people,
> I am new to PL/SQL and i have a question. I have a function
> shipfunct(item_no integer, shiptype char) which is as:
> create or replace function shipfunct (item_no integer, shiptype char)
>.....
> error:
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'SHIPFUNCT
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> please help me solve this. I run Oracle 8i on a standalone Windows NT.
> help truly appreciated.
> Oracle_learner.

Hi Oracle_learner :)

Your function requires a character as second argument. Try to call your function this way:

shipfunct(179, 'U'); Received on Sat May 10 2003 - 03:44:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US