Re: Can anyone help me out of this question.

From: <barx_at_my-deja.com>
Date: Tue, 17 Oct 2000 07:07:37 GMT
Message-ID: <8sgtrn$k3$1@nnrp1.deja.com>

try referencing your parameters the following way

functionname.parametername

   insert into sArticles

                       (ArticleId, CreationDate, Author)
        values
                  (sArticleSequence.NextVal,

INSERT_ARTICLE.CreationDateIn, INSERT_ARTICLE.AuthorIn);

otherwise it looks pretty good to me.

In article <8sfv6l$8te$1_at_nnrp1.deja.com>,   sasha2012_at_my-deja.com wrote:
> Can you find anything wrong w/ this?
>
> create function INSERT_ARTICLE(CreationDateIn IN VARCHAR2, AuthorIn IN
> VARCHAR2)
> RETURN NUMBER
> IS
> sArticleSequence.RowID NUMBER;
> BEGIN
> insert into sArticles
> (ArticleId, CreationDate, Author)
> values
> (sArticleSequence.NextVal, CreationDateIn, AuthorIn);
> RETURN (sArticleSequence.RowID);
> END;
>
> I GET these errors:
> (sArticleSequence.NextVal, CreationDateIn, AuthorIn);
> *
> ORA-06550: line 5, column 45:
> PLS-00201: identifier 'CREATIONDATEIN' must be declared
> ORA-06550: line 2, column 3:
> PL/SQL: SQL Statement ignored
> ORA-06550: line 6, column 1:
> PLS-00372: In a procedure, RETURN statement cannot contain an
 expression
> ORA-06550: line 6, column 1:
> PL/SQL: Statement ignored
>
> Thanks for your help.
>
> Sasha.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 17 2000 - 02:07:37 CDT