A PL/SQL Parse error occurred [message #252043] |
Tue, 17 July 2007 13:13 |
bigpapi
Messages: 6 Registered: June 2007
|
Junior Member |
|
|
I am getting the following error when i try to create a new package in PL/SQL.
Any ideas on what to do to fix this??? Here is my code:
CREATE OR REPLACE PACKAGE CRYSTAL_REPORTS_CURSORS AS
TYPE rec_test_report is record(
call_code ___________ call_code.call_code%type,
erncd _______________ time_entry_calls.erncd%type,
earns_begin_dt_______ time_entry_calls.earns_begin_dt%type);
TYPE test_report IS REF CURSOR
RETURN rec_test_report;
END CRYSTAL_REPORTS_CURSORS;
**** I only added the underscore lines in the code to make it easier to read.
when i run a query against my all errors table it returns the following descriptions as problems in my code:
TEXT
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Declaration ignored
The line corresponding to the errors are the first two lines of the is record command
|
|
|
|
|
|