Re: PL/SQL Question

In article <33l722$7oh_at_agate.berkeley.edu>, davidc_at_AlleleB.Berkeley.EDU () writes:
> kkc_at_nauvax.ucc.nau.edu wrote:
> [snip]
> : We are running ORACLE 7.0.15. . . .
 [snip]
> : I cannot edit and interactively run PL/SQL routines
> : within SQLPLUS. I can issue a start command from within SQLPLUS and this will
> : work, but this requires that I exit out to my editor, save, and come back
> : into SQLPLUS and start the saved routine rather than editing within SQLPLUS
> : and using the / to run my edit buffer?
 

> : When I took the ORACLE class we were able to interactively edit. . . .
 [snip]
> : Is there a way to edit and interactively run PL/SQL scripts from
> : within SQLPLUS??
>
> I've seen this before. When you run SQL*Plus, take note of the
> messages that appear just before the SQL> prompt. There should be two
> of them, one specifying the version of the RDBMS to which you have
> connected, and the second one specifying the version of the PL/SQL
> parser. My guess is that you will not see the second one. This means
> that your PL/SQL parser is not getting called, and it results
> from an error in the installation of ORACLE 7.0.15, according to the
> DBAs I've spoken to recently. I haven't installed a version later than
> 6.0.24 myself, but my impression is that you just need to rerun the
> installation scripts with the right options.
> Hope this helps.
> David Clement
> Consultant in ORACLE, UNIX, C
>
> =====================================================================
> davidc_at_alleleb.berkeley.edu
> =====================================================================
> Sure I work for the phone company. Doesn't everybody?
> =====================================================================

When I have had this problem, it is because I have forgotted to specify that I want the procedural option. As David mentioned above, when you connect, you should messages like these

Connected to:
ORACLE7 Server Release 7.0.16.4.0 - Production With the procedural and distributed options PL/SQL Release 2.0.18.1.0 - Production

If you don't get the procedural option message, you need to re-link or reinstall the product to include the procedural option.

You don't mention which operating system you are using. Under VMS, you run ORACLEINS and change the configuration options under the RDBMS to include the procedural option. Under UNIX, you run orainst and select the procedural option as one of the items to install.

Note that until 7.1, the procedural option is a separately licensed product. You shouldn't turn it on unless you have paid for it.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285