Stored Package

From: (wrong string) ¤_at_ ¶§ «ü <(¤_at_>
Date: 1996/03/06
Message-ID: <4hitgt$2as_at_platinum.hkabc.net>#1/1


Hi,

        I have tried to create a package using the example in Page 7-5 in the menu "PL/SQL User's Guide and Reference".

	CREATE OR REPLACE PACKAGE trans_data AS
		 TYPE TimeTyp IS RECORD (
			minute  SMALLINT,
			hour    SMALLINT);

		 TYPE TransTyp IS RECORD (
			 category    VARCHAR2,
			account     INTEGER,
			amount      REAL,
			 time        TimeTyp);

		minimum_balance     CONSTANT REAL :=10.00;
		number_processed    INTEGER;
		insufficient_funds  EXCEPTION;
	END trans_data;
	/

	There was an error "Warning: Package created with compilation errors."

	I have some questions to ask:
	1. How can I know what's wrong when there is such error;
	2. I tried to change VARCHAR2 of the category to CHAR. There was not 	
	    error. Why?
	3. I want to declare a type using ROWTYPE as follows:
	     TYPE emp_rec IS emp%ROWTYPE
	    What's wrong?

	Thanks!
Received on Wed Mar 06 1996 - 00:00:00 CET

Original text of this message