Garg, Piyush (EM, GECIS) wrote:
Hi Everybody,

Is there any way we can tranform the Stores procedure and Triggers present under Oracle Custom Application to mysql.
Please tell ways or any tools which can help us rewrite the logic in Mysql.

Thanks and regards,
Piyush
  
Stored Procedures are only supported in version 5.0.x and above ( which is currnetly a development release ).
Triggers will be longer still.
You can get trigger-like functionality by creating functions in your application to manage the updating of your DB, and always using those functions instead of talking directly to the DB server. This is more flexible, but slower. Anyway, it's the only option currently.

Dan

--
signature Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to