Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2013
    Posts
    4

    Unanswered: urgent : oracle error

    what does this:

    9/1 PLS-00103: Encountered the symbol "NESTED" when expecting one of
    the following:
    ; not alter final instantiable

    mean?
    if the error itself does not help you answer my question i can post the code i executed (but for security reasons i am not going to do it right now). just tell me & i'll post it.

    PLEASE, PLEASE, PLEASE I need your help. THX in advance
    Last edited by anonsk964; 03-19-13 at 16:53.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by anonsk964 View Post
    what does this:

    9/1 PLS-00103: Encountered the symbol "NESTED" when expecting one of
    the following:
    ; not alter final instantiable

    mean?
    if the error itself does not help you answer my question i can post the code i executed (but for security reasons i am not going to do it right now). just tell me & i'll post it.

    PLEASE, PLEASE, PLEASE I need your help. THX in advance
    That indicates SYTAX error.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Mar 2013
    Posts
    4

    I know

    sorry, i deleted my code for security reasons. i hope you understand.
    Last edited by anonsk964; 03-20-13 at 07:26.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    The last statement should be a CREATE TABLE, not CREATE TYPE (unless I'm wrong).
    Code:
    SQL> CREATE TYPE t_sig AS OBJECT
      2         (droit INTEGER, cptcourant INTEGER);
      3  /
    
    Type created.
    
    SQL> CREATE TYPE nt_sig AS TABLE OF t_sig;
      2  /
    
    Type created.
    
    SQL> CREATE TYPE t_telephone AS OBJECT
      2         (numtel INTEGER);
      3  /
    
    Type created.
    
    SQL> CREATE TYPE v_telephone AS VARRAY (3) OF t_telephone;
      2  /
    
    Type created.
    
    SQL> CREATE TABLE t_client
      2  (
      3     nclient      INTEGER,
      4     nom          VARCHAR (50),
      5     adresse      VARCHAR (50),
      6     signatures   nt_sig,
      7     tel          v_telephone,
      8     email        VARCHAR (50)
      9  )
     10  NESTED TABLE signatures
     11     STORE AS sig_table;
    
    Table created.
    
    SQL>

  5. #5
    Join Date
    Mar 2013
    Posts
    4

    Thank you!!!!!!!!!!!!!

    thank you so much, you saved my life!!!!

  6. #6
    Join Date
    Mar 2013
    Posts
    4
    ok sorry for the previous message
    Last edited by anonsk964; 03-20-13 at 08:04.

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by anonsk964 View Post
    Littlefoot, could you please delete your post? thx!
    That code does not reveal anything that is "security" relevant.

    Deleting the code from your intial question is quite impolite because now this thread now is totally useless to anyone looking at it.

    If you want private non-public help hire a professional Oracle consultant (and let him/her sign a non-disclosure agreement).

    But as soon as you put stuff here, it's totally useless to tried to hide anything. Public forums don't work this way.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by shammat View Post
    . . .
    Deleting the code from your intial question is quite impolite because now this thread now is totally useless to anyone looking at it.
    . . .
    Perhaps OP wants to hide the code in order his manager not find out he does not know any sql or pl/sql.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •