Re: Pl/sql internal error [] [] [] [] []
Date: 1996/06/18
Message-ID: <4q76nv$79t_at_news1.infinet.com>#1/1
In <31C611EF.179F_at_interbrat.com>, kroll <kroll_at_interbrat.com> writes:
>Marc Bowden wrote:
>>
>> Hi All
>>
>> I am getting this error message in a pl/sql package. Prob;lem appears
>> to be in the Body. Can anyone suggest any possible causes (part from
>> the size of the package)? Thanks!
>>
>> A Bientot
>> Marc
>
>
> Unfortunately this could be just about anything. The only
Some problems that I've encountered that cause internal PL/SQL errors are: 1) missing %type in variable declaration
e.g. procedure foo (bar in table.column) is <-- missing "%type"
begin
null;
end;
2) Wrong number of bind variables in a fetch
cursor c1 is select a, b, c from table_a;
....
fetch c1 into a, b;
I have a list of about 5 different things that could cause internal errors at work. If neither of these fix your problem, email me and I'll try to get you the list by the end of the week.
Kevin Toepke
+------------------------------------------+----------------------------------+ | Kevin Toepke | Nothing was ever accomplished by | | ktoepke_at_infinet.com | a reasonable man. | | | -- George Bernard Shaw | +------------------------------------------+----------------------------------+Received on Tue Jun 18 1996 - 00:00:00 CEST