Stored Package
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