| REP-1401 fatal PL/SQL error [message #283369] |
Mon, 26 November 2007 23:32  |
Qaiser.Bashir
Messages: 32
Registered: July 2007
Location: Rawalpindi
|
Member |
|
|
hi i m using the formula column and facing the above mentioned problem can any one help....to solve it...
function Disease return Char is
vDisease varchar2(500);
begin
select descr into vDisease from opd$icd where Code in (select a.FINDIAGNOSIS || a.PROVDIAGNOSIS || a.DIFFDIAGNOSIS
from OPD$Diagnosis a, OPD$ICD b
where a.regnum=:regnum
and (a.PROVDIAGNOSIS = b.code
OR a.DIFFDIAGNOSIS = b.code
OR a.FINDIAGNOSIS = b.CODE )
and b.CHRONIC = 'Y'
and a.visitdate between :P_FROMDATE and :P_TODATE);
return(vDisease);
exception when others then
return (sqlerrm);
end;
and after this another error occured rep-0619 u cannot run with out layout
|
|
|
|
|
|
|
|
| Re: REP-1401 fatal PL/SQL error [message #283425 is a reply to message #283409] |
Tue, 27 November 2007 02:13  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
First of all, I apologize: this was a nonsense:
| Quote: |
... use SUBSTR function to cut off 'a.FINDIAGNOSIS || a.PROVDIAGNOSIS || a.DIFFDIAGNOSIS' size to max 500 characters
|
I didn't read your query carefully enough. If SUBSTR needs to be used, it is the 'descr' column it should be applied to.
In order to avoid such misunderstandings, please, read the OraFAQ Forum Guide to learn how to properly format your code (using the [code] tags).
Could you, please, post your current function code (do use [code] tags, please!) and, possibly, result of this SELECT statement when ran in SQL*Plus. Don't forget to remove the WHEN OTHERS exception handler.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
