Re: Error SP2-0309

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 03 May 2002 19:09:04 +0200
Message-ID: <5vg5duoc8n6qfjvborkjgmp7nv1amof0k7@4ax.com>

On Fri, 3 May 2002 09:26:47 +0200, "Vanessa Berni" <v.berni_at_ui.prato.it> wrote:

>I'm using Oracle8i
>
>I've got this problem:
>
>I've created a simple interface (for the "shell") :
>
> MENU
>
>1. Add user in table Login
>2. Delete user
>3. ......
>
>9. Return to previous Menu
>0. Exit
>
>the command associated with "1 " is simply a "start d:\1\Add.sql"
>the commnad associated with "2" is "execute NameProcedure"
>..
>
>The problem is that I've got several of this menu and the error I get is:
>
> SP2-0309 SQL*Plus command procedures may only be nested to a depth
>of
> number_of_nested_procedures
>
>
>What can I do?!?!?
>Is it possible to "close" in some way the previous menu!?!?!
>
>
>When I exit from menu I get the error "Broken String at character 14"
>
>Some ideas?
>
>Thank you
>
>

Sure. Oracle ships OEM and DBA studio for this purpose. Sql*plus is basically a Command Line Interface with some reporting facilities and nothing more.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 03 2002 - 12:09:04 CDT