Re: SQL*Plus Procedure Help Needed

In article <93198.103400AI4CPHYW_at_MIAMIU.BITNET> <AI4CPHYW_at_MIAMIU.BITNET> writes:
>Hello There:
>
>I have been working with SQL*Plus under Oracle 6 running "one line"
>queries (i.e select foo from bar where baz = bang) with no problems.
>Recently, I wanted to get into some procedures using looping
>constructs and stuff as described in the PL/SQL book, except I can't
>seem to get SQL*Plus to accept the commands.
>
>For example, if I key in (either to a text file or direct at the SQL>
>prompt):
>
> DECLARE
> x char(20);
> BEGIN
> .
> .
> .
> END;
>
>SQL*Plus chokes on the DECLARE saying it is an invalid SQL command.
>Now, as far as I understand from the PL/SQL and SQL*Plus books,
>SQL*Plus should run procedures like that without comment. I can, of
>course, run a procedure like the above in a SQL*Forms 3 trigger, but
>I'd like to make SQL*Plus do it too. Could I be missing a setting, or
>do I need another product to make the thing work ?
>
>Thanks for your help.
>
> -Alec D. Isaacson
> AI4CPHYW _at_ miamiu.acs.muohio.edu
> isaacson _at_ rogue.acs.muohio.edu (NeXt Mail)
> Miami University, Oxford, OH
>-------------------------------------------------------------------------
>"They teach many things in Baptist colleges, but the short-arm jab as
> a means of converting the ungodly is not one of them"
> -Frederick Forsyth, _The_Deceiver_

Check the version number of SQL*Plus when you start it up. If you see the wrong number, probably you still have the old SQL*Plus executable on your machine and your PATH environment variable (or logical name) is not set properly. Did you have ORACLE version 5.x before installing 6.0? Also, did you purchase your dbase with transaction processing option? (SQL*Forms has its own built-in PL/SQL engine). If you didnt, you won't be able to access PL/SQL from SQL*Plus.

   Hope this helps:

                       Janos Geller (jgeller_at_panix.com)