Mailing List
Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
ODBC - ODBC with the MySQL Connector/ODBC driver
Perl - Perl support for MySQL with DBI and DBD::mysql
MySQL++ - Programming with the C++ API to MySQL
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
Mysql 4.0 -Oracle Stored Procedure Trigger Conversion

Mysql 4.0 -Oracle Stored Procedure Trigger Conversion

2004-03-17       - By Daniel Kasak

 Back
Reply:     1     2  

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

--
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: dkasak@(protected)
website: http://www.nusconsulting.com.au

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " >
<html >
<head >
<meta content= "text/html;charset=ISO-8859-1 " http-equiv= "Content-Type " >
<title > </title >
</head >
<body bgcolor= "#ffffff " text= "#000000 " >
Garg, Piyush (EM, GECIS) wrote: <br >
<blockquote
cite= "mid5E3843DB4824E2469926DCF5432748E4346B4F@(protected) "
type= "cite " >
<pre wrap= " " >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
</pre >
</blockquote >
Stored Procedures are only supported in version 5.0.x and above ( which
is currnetly a development release ). <br >
Triggers will be longer still. <br >
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. <br >
<br >
Dan <br >
<br >
<div class= "moz-signature " >-- <br >
<meta http-equiv= "content-type " content= "text/html; charset=ISO-8859-1 " >
<title >signature </title >
Daniel Kasak
<br >
IT Developer
<br >
<span style= "font-weight: bold; " >NUS Consulting Group
</span > <br >
Level 5, 77 Pacific Highway
<br >
North Sydney, NSW, Australia 2060
<br >
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
<br >
email: <a href= "mailto:dkasak@(protected) "
class= "moz-txt-link-abbreviated " >dkasak@(protected) </a >
<br >
website: <a href= " http://www.nusconsulting.com.au "
class= "moz-txt-link-freetext " > http://www.nusconsulting.com.au </a >
</div >
</body >
</html >

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql @(protected)