Create A Table For Reports 2.5

From: KRM <malleykr_at_my-deja.com>
Date: Wed, 28 Jul 1999 12:49:21 GMT
Message-ID: <7nmu8f$qsa$1_at_nnrp1.deja.com>

I am trying to create a table within a Report. I am trying to create it in a package, so that I will be able to access the data after the report has run. I am using Reports 2.5, and Oracle's web site says that I can use PL/SQL version 1.1 with this software. I tried to use the following bit of code to create the table type ATable:

PACKAGE MyPackage IS

   TYPE ARecord IS RECORD (

      Pkg_Contract_Nbr char,
      Pkg_Do_Nbr char,
      Pkg_Category_Code char,
      Pkg_Product_Nbr char,
      Pkg_Serial_Nbr char);

   TYPE ATable IS TABLE OF ARecord
         INDEX BY BINARY_INTEGER;

END; However, I am getting the error:
ERROR 103 at line 10, column 25
  Encountered the symbol "OF" when expecting one of the following: "("
Fatal syntax error, unable to recover.

I got the basic syntax from Oracle's web page, and adapted it to my needs. I tried a straight copy of their code into mine, and it didn't like the word "OF" in their code, either. Is this a difference between PL/SQL 2.0 and 1.1? If so, could someone please tell me the correct syntax?

Thanks!
Kristen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 14:49:21 CEST