Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    Ontario, Canada
    Posts
    19

    Unanswered: PL/SQL cursors and index tables

    I'm trying to write a script that stores values in an index table using a cursor. My syntax looks write but i'm getting the following message:

    Please enter the number of rows to be selected: 5
    last_name_tbl last_name_tbl_type;
    *
    ERROR at line 9:
    ORA-06550: line 43, column 27:
    PL/SQL: ORA-00923: FROM keyword not found where expected
    ORA-06550: line 43, column 4:
    PL/SQL: SQL Statement ignored

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: PL/SQL cursors and index tables

    Originally posted by bbk
    I'm trying to write a script that stores values in an index table using a cursor. My syntax looks write but i'm getting the following message:

    Please enter the number of rows to be selected: 5
    last_name_tbl last_name_tbl_type;
    *
    ERROR at line 9:
    ORA-06550: line 43, column 27:
    PL/SQL: ORA-00923: FROM keyword not found where expected
    ORA-06550: line 43, column 4:
    PL/SQL: SQL Statement ignored
    Show your code

Posting Permissions

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