raise_application_error and ora-06512

From: Pieter-Jan <diepenpj_at_hotmail.com>
Date: Wed, 04 Nov 1998 10:05:17 GMT
Message-ID: <364026c5.9012410_at_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 Wed Nov 04 1998 - 11:05:17 CET

Original text of this message