Re: Sql*Forms 3.0 question

In article <2d2jad$4hq_at_bwc.bwc.org> foad_at_bwc.org (Foad Shodjai) writes:
>
>I appreciate help with this item: I have a form in which I keep
>the name of plsql/sqlforms procedure in a field. I wish to execute
>the procedure whose name is in the field. (again, the procedure
>I wish toi run is defined in the current form, and not in the database)
>
>In 2.3 it was easy: execute_trigger(&field_name)
>with '&' we did an indirect addressing.
>
>in 3.0 name_in() function is not helpful in this case, since running a
>procedure is done by simply typing its name in the body lines, and not
>by call to another function such as execute_trigger.
>
>Any ideas?
>Thx
>Foad
>--
>+---------------------------------------------------------------------------+
>| Foad Shodjai Tel.Off.: 972(4)358358 TELEX: 46626 (BAYT IL) |
>| PO Box 155 Tel.Res.: 972(4)514876 UUCP: uunet!bwc!foad |
>| Haifa, 31 001 FAX DP : 972(4)358525 Internet: foad_at_bwc.org |
>| Israel. FAX 2 : 972(4)358280 Dialcom: 5005:BAI001 |
>+---------------------------------------------------------------------------+

Dear Foad,

Pleasure to see your name in the net. This problem has been in there since the beginning and there is no easy solution to it. However, one way we resolved it, was to have a corresponding trigger for every procedure. For example

	 PROCEDURE CALCULATE_SUMMARY is
	 ...
	 END OF PROCEDURE

	 TRIGGER DO_CALCUALTE_SUMMARY 
	   CALCULATE_SUMMARY
	 END OF TRIGGER

In this way you can do execute_trigger('DO_'||&:BLK.PROC_NAME);

Hope this works. I am a bit rusty so the syntaxes may not bbe perfect.

Take care.

Shahrooz Tedjarati
Unisys China and Hong Kong
stedjara_at_unisys.hk.net

p.s. We have reported this to Oracle. Hope to see them implement it properly through somethig like execute_procedure(&var_name); Received on Sat Nov 27 1993 - 07:12:58 CET