Raise_application_error and ora06512

From: Pieter-Jan <diepenpj_at_hotmail.com>
Date: Tue, 03 Nov 1998 14:42:13 GMT
Message-ID: <363f1434.25106564@news.xs4all.nl>

hello

I've build a function with a exception. In that exception is programmed a Raise_application_error. The function is good.

When i use that function in a forms trigger, :itemtot := chk_itemtot (:prodid,:price,:qty); exception

	when others then
	message(sqlerrm);

end;

I get the message programmed in raise_application_error but with Ora-06512 at "scott.check_itemtot line19 and ora06512 at line 1

what could be wrong?

thanks pieter-jan Received on Tue Nov 03 1998 - 08:42:13 CST