Wrong procedure execution???

From: Jacques Sireude <sireude_at_eiffel.com>
Date: Thu, 9 Jul 1998 16:56:45 -0700
Message-ID: <6o3lae$4n1$1@news.rain.org>

Hi,

    I created a procedure this way:

create procedure DB_BOOK_PROC (name VARCHAR2) as TMP DB_BOOK%rowtype; BEGIN select * into TMP from DB_BOOK where AUTHOR = name; END;

Then I execute it this way:

execute DB_BOOK_PROC ('sireude')

And it does not work... It says: invalid SQL statement.

If someone knows what to do, his help would be appreciate.

Best regards,
Jacques.

---

---

Jacques SIREUDE
6585 PICASSO Rd Apt#3
ISLA VISTA CA 93117
USA
tel/fax: 1-805-685-9208
e-mail: sireude_at_eiffel.com

             jacques.sireude_at_enst-bretagne.fr

http://www-eleves.enst-bretagne.fr/~sireude



----------------------------------------------------------------------------


----------------

Received on Thu Jul 09 1998 - 18:56:45 CDT