MS ACCESS to PL/SQL converter

[anithas]

Hi,

Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL

[willakawill]

Hi. I am curious about the use of the word 'macro' in this context. What, exactly, do you want to port?

[MMcCarthy]

Hi,

Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL

As willakawill says it all depends on what the macro is doing. A lot of macro functionality won't have an equivalent oracle/sql command. If you tell us what the macro is doing we may be able to give you a better idea.

[anithas]

As willakawill says it all depends on what the macro is doing. A lot of macro functionality won't have an equivalent oracle/sql command. If you tell us what the macro is doing we may be able to give you a better idea.

Thanks for ur response....its a macro which when executed, runs a list of SQL queries written in MS access.

Now i have to write these MS access queries to PL/SQL procedures...th ough the syntax is more or less similar in structure.....i f i have any converter tool...i can cross verify the syntax and help me

To put it staright....i need the name of any tool...which will convert MS aCCESS sQL queries to Pl/SQL

[willakawill]

If you go to each query in Access, switch to design mode and, on the menu, click view|sql you will see the sql syntax that you need.

[MMcCarthy]

Thanks for ur response....its a macro which when executed, runs a list of SQL queries written in MS access.

Now i have to write these MS access queries to PL/SQL procedures...th ough the syntax is more or less similar in structure.....i f i have any converter tool...i can cross verify the syntax and help me

To put it staright....i need the name of any tool...which will convert MS aCCESS sQL queries to Pl/SQL

Unless the queries contain access functions that are not standard aggregate they shouldn't require any conversion.

[NeoPa]

Hi,

Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL

I guess no-one here knows of any such tools or reference :(
Have you tried asking in the Oracle forum?