Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Error SP2-0309

Error SP2-0309

From: Vanessa Berni <v.berni_at_ui.prato.it>
Date: Fri, 3 May 2002 09:26:47 +0200
Message-ID: <aatduh$12djk$1@news02.it.net>


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. ......
  4. Return to previous Menu
  5. 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 Received on Fri May 03 2002 - 02:26:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US