Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: procedure with varray wont compile

    i get a ora-00922 on compiling the following watered-down version of my varray usage. please help if you see what's going on here..

    create or replace type VARCHAR_ARRAY as table of VARCHAR2(300);

    CREATE OR REPLACE procedure delete_comp( array_in in VARCHAR_ARRAY )
    AS
    begin
    for i in 1..array_in.count loop
    dbms_output.put_line( array_in(i) );
    end loop;
    end;

    THANKS!

  2. #2
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    I don't see a varray.

    The procedure works for me though (Oracle 10.1).

  3. #3
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    It's working for me too, Oracle 9i (9.2.0.5)

Posting Permissions

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