Home Forums SQL Server 2005 Working with Oracle CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS RE: CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

  • November 12, 2011 at 5:38 am

    #1406691

    shubham.saxena67 (11/12/2011)

    Dear Friends,

    I want to convert stored procedure that containing Loops ,Table valued

    functions,Scalar Function written in Oracle to SQL Procedure and functions

    Is there any tool ?

    Thanks!!

    no, there's no set of specific rules that could be applied to convert a proc; only basic insert/update/select/delete can be converted by applying specific rules or find/replace.

    you'll have to rewrite the proc for SQL, and vice versa.

    if you post it, and it's not to huge, one of our volunteers might take a stab at it, or at least give you a push in the right direction.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!