| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL and SQL Plus
On Tue, 07 Sep 1999 13:58:26 GMT, finana_at_my-deja.com wrote:
>I'm having difficulties executing SQL Plus from PL/SQL. Any
>suggestions?
You can't execute SQL*Plus commands from PL/SQL. The reason is that PL/SQL is a programming language, and PL/SQL program units execute inside the database. SQL*Plus is a client program that provides an interface that you can use to send SQL queries, and PL/SQL blocks, to Oracle. The SQL*Plus interface makes this somewhat confusing, because it doesn't require you to distinguish between commands to the tool, and queries and blocks being submitted to the database. Everything gets typed into that one window.
Jonathan
 |
 |