[Openroad-users] Dynamic Procedures

[hdgcontact-2007 at yahoo.co.uk]

Greg,

Contrary to Bodo I assumed you were talking about ingres procedures. In that case, if you know the procedures by name, you can use drop procedure. But for that you would need to store the name in an array or a table.
 
What I would do is give generic name to procedures i.e. prc_dyn0001 .. prc_dyn9999 when creating them, and use a select loop to drop them.
 
procedure DropDynProcs () = 
declare
  Lcl_ProcName          = varchar(32) not null;
enddeclare
Begin
  select :lcl_ProcName = procedure_name
  from iiprocedures
  where procedure_name like 'prc_dyn____'
  begin
    drop procedure :lcl_ProcName;
  end;
  commit;
end;
 
You could add schema verification and appropriate error trapping to that code.
I hoe that helps
Hevé



----- Original Message ----
From: Bodo Bergmann <Bodo.Bergmann at ingres.com>
To: International OpenROAD Users <openroad-users at peerlessit.com>
Sent: Thursday, 6 September, 2007 8:49:36 AM
Subject: Re: [Openroad-users] Dynamic Procedures


 
Setting
    Proc4GLSource.ParentApplication = NULL;
should do the job.
 
Regards,
Bodo.
 
Bodo Bergmann
Senior Software Engineer
OpenROAD Worldwide Development
Ingres Corp.
 




From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Greg Wilding
Sent: Thursday, September 06, 2007 7:23 AM
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Dynamic Procedures


Hi All 
Our current application creates dynamic procedures on the fly - does anybody know it you can purge dynamic procedures once they have been created
Thanks 
Greg Wilding 
Senior Analyst Programmer 
ING Australia 
Business Technology - Life Risk & Direct Insurances 
Level 5, 68 Pitt Street SYDNEY 2000 
T  (02) 8238 3663, F (02) 8238 3671 
E greg.wilding at ing.com.au 


IMPORTANT NOTICE 
This communication including any file attachments is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, or the person responsible for delivering this communication to the intended recipient, please immediately notify the sender by e-mail and delete the original transmission and its contents. Any unauthorised use, dissemination, forwarding, printing, or copying of this communication including any file attachments is prohibited. 
It is your responsibility to scan this communication including any file attachment for viruses and other defects. To the extent permitted by law, ING and its associates will not be liable for any loss or damage arising in any way from this communication including file attachments.


      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/ 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20070906/4b9068d8/attachment.html