Get "Not Found" error message when use varray
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Get "Not Found" error message when use varray

  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Get "Not Found" error message when use varray

    Hi,
    I would say that it is really strange, I declared my varray as below:

    type late_arr is varray(14) of number;
    cur_late late_arr := late_arr();

    when I try to assign value to the array using for loop it caused problem. This is the error msg.
    Not Found
    The requested URL /pls/prod_portal30/PORTALDEV.SAM_REPORT.show was not found on this server.

    I tried to use
    cur_late(1) := 2;
    also generate same error.
    Pls help.

    p/s: I'm using the PL/SQL to create application in the Oracle Portal
    and the Application Component item type is Dynamic Page.
    Last edited by charon; 01-19-2004 at 10:27 PM.

  2. #2
    Join Date
    Nov 2003
    Posts
    4

    Problem Solved, But Confused

    Hi,
    the problem has been solved by using :
    cur_late.extend(1);
    cur_late(1) := 2;

    just curious to know why???
    I have already specified its type of definition and its maximum size of the varray => type late_arr is varray(14) of number;

    why we still need to use Extend method in order to assign value to the varray??? I'm not going to use more than the max size, why should I extend it??Doesn't the Extend Method is used for increasing the size of a collection.

    Pls Help.
    Last edited by charon; 01-19-2004 at 11:43 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width