Do you mean that you want to translate SqlServer (T-SQL) stored procedures
to Oracle (PL-SQL) ??

It's not possible to do that automatically. They will need to be completely
rewritten.

Alistair Connor
Ext/Astek
DBA Sql Server
tél 598131


-----Message d'origine-----
De : Thiagarajan Gopalakrishnan
[mailto:Thiagarajan.[Email Address Removed]
Envoyé : vendredi 27 décembre 2002 07:39
À : LazyDBA.com Discussion
Objet : SQL to Oracle Replication

Hi All

I am trying to replicate the execution of a Stored Procedure from
SQL Server 2000 to Oracle. But i am getting an ODBC Escape Error.
I am using OLEDB for Oracle.
Could anyone help me out with this. This is urgent.

Note : I am able to successfully replicate Tables.

Thanks And Regards

PG Thiagarajan
Never say "oops!" always say "ah, Interesting!"


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page