Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: please help me out...
"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
![]() |
![]() |