Home » SQL & PL/SQL » SQL & PL/SQL » A PL/SQL Parse error occurred
A PL/SQL Parse error occurred [message #252043] Tue, 17 July 2007 13:13 Go to next message
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

Re: A PL/SQL Parse error occurred [message #252047 is a reply to message #252043] Tue, 17 July 2007 13:17 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you change this
TYPE test_report IS REF CURSOR
RETURN rec_test_report;
with this
TYPE test_report IS REF CURSOR;
Re: A PL/SQL Parse error occurred [message #252049 is a reply to message #252047] Tue, 17 July 2007 13:20 Go to previous messageGo to next message
bigpapi
Messages: 6
Registered: June 2007
Junior Member
Same thing.....

Same Errors....
Re: A PL/SQL Parse error occurred [message #252050 is a reply to message #252043] Tue, 17 July 2007 13:20 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can format your post, just read How to format your posts

Regards
Michel
Previous Topic: quota
Next Topic: query counting number of records
Goto Forum:
  


Current Time: Sat Dec 10 22:16:28 CST 2016

Total time taken to generate the page: 0.09719 seconds