Re: SQLPLUS and PL/SQL

I just ty you procedure and this work fine. I make the test with oracle 8.

the problem should be version synthax. perhaps you can try to replace

CREATE PROCEDURE simple ( value IN INTEGER ) AS

with

CREATE PROCEDURE simple ( value IN INTEGER ) IS

for books, you can check for PL/SQL books available from different editors :

O'reilly : Oracle pl/SQL programming from . Feuerstein & B. Pribyl Sams Publishing : PL/SQL in 21 days.
Oracle Press- Osborne : PL/SQL programming

In article <6dkcb9$sr5_at_dupre.cs.colostate.edu>, hudnall_at_dupre.cs.colostate.edu (corby hudnall) wrote:
>Hi all, I'm a student taking an intro database class and I have a professor
>that either doesn't know or doesn't care to know anything about what he's
>"teaching" us. I am trying to figure out PL/SQL with only the online help
>to guide me and I'm having some difficulty. Specifically, SQLPlus won't
>recognize BEGIN or DECLARE as valid SQL statements. When I try this:
>
>CREATE PROCEDURE simple ( value IN INTEGER ) AS
>BEGIN
> RETURN;
>END simple;
>/
>
>I get an error at the opening paren stating it's not a valid SQL statement.
>I've tried anonymous blocks as simple as
>
>BEGIN
>END;
>
>but again, I'm told that BEGIN is not a valid SQL statement. Stabbing in
>the dark has gotten me no where so any direction you can offer is GREATLY
>appreciated!
>
>What do i have to do to make this work? Can anyone PLEASE recommend a good
>book that will guide me through the particulars of SQL.
>
>FYI, I'm using SQLPlus ver. 3.2.300 and Oracle7 server 7.2.3.0.0.
>
>cheers

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Wed Mar 04 1998 - 00:00:00 CET