Re: Creating server-procedures in Des2K

From: Jacek Dobosz <jdob_at_nospam.ping.at>
Date: 1998/01/19
Message-ID: <34c3b309.5963843_at_news.ping.at>#1/1


On Mon, 19 Jan 1998 10:34:00 -0800, Maarten Scharroo <m.scharroo_at_elsevier.nl> wrote:

>Can I trap user-defined exception ( like -1031 i.e insufficient
>privileges ) in a procedure generated by Designer 2000 version 1.3.2
>using the declarative approach. (Free format set to false )
>

Yes, you can do it.

  • define your exception in the "Program Data" section of the procedure or function
  • assign "Construction Type" Exception to it
  • define the pragma text in the "Data Construct Definition" property in the text section of the exception

In my example properties of Program Data element

Name: fatal_error
Construct Type: Exception ( pop list )
Data Construct Definition: PRAGMA EXCEPTION_INIT(fatal_error,-20000);

jacek

+-----------------------------------------+
| if you want to replay, use jdob_at_ping.at |
| or remove nospam from the address       |
+-----------------------------------------+       
Received on Mon Jan 19 1998 - 00:00:00 CET

Original text of this message