How to convert the sql statement from Oracle to MySQL

[jenny chen]

Hi,

I'm running some sql statements to create table in the database. The statements are working fine in Oracle DB server. However, if I run those sql statement in MySQL DB server, it just simply throw the syntax error. Could you please let me know why these sql statement cannot work on MySQL and how to migrate them from Oracle to MySQL?

Thanks in advance for the reply!

Here are the statements:

create table Bigint_Tab (MAX_VAL NUMBER(19,0), MIN_VAL NUMBER(19,0), NULL_VAL NUMBER(19,0) NULL)

create table Binary_Tab (BINARY_VAL RAW(24) NULL)

create table Varbinary_Tab (VARBINARY_VAL RAW(48) NULL)

create procedure Numeric_Proc (MAX_PARAM out NUMBER, MIN_PARAM out NUMBER, NULL_PARAM out NUMBER) as begin select MAX_VAL, MIN_VAL, NULL_VAL into MAX_PARAM, MIN_PARAM, NULL_PARAM from Numeric_Tab; end;