Help::: Convertng Sql(T-Sql) Stored Proc To Oracle(Pl-Sql)

[iTeachSAP]

[quote name='mtkr' timestamp='1355164480' post='1302925260']
thnx a lot mama... ltt chesthu untaaa
[/quote]


sure bayya... evaraina ee lopala response istheremo chudu .. so that i too can save some time ..

[mtkr]

[quote name='iTeachSAP' timestamp='1355164974' post='1302925343']


sure bayya... evaraina ee lopala response istheremo chudu .. so that i too can save some time ..
[/quote]

ya bayya...pakka...

[peru_edaite_enti]

[quote name='mtkr' timestamp='1355165165' post='1302925375']
ya bayya...pakka...
[/quote]

ya bayya...pakka...

[mtkr]

[quote name='CBZ' timestamp='1355165228' post='1302925389']
ya bayya...pakka...
[/quote]
copy paste kaadu mundhu convert chesi pampeiii...
enduku untarr vaiiii

[peru_edaite_enti]

[quote name='mtkr' timestamp='1355165290' post='1302925409']
copy paste kaadu mundhu convert chesi pampeiii...
enduku untarr vaiiii
[/quote]

WIP

[mtkr]

[quote name='CBZ' timestamp='1355165333' post='1302925420']
WIP
[/quote]

status?

[peru_edaite_enti]

[quote name='mtkr' timestamp='1355165460' post='1302925448']
status?
[/quote]

5%, wip, eta eod

[mtkr]

[quote name='CBZ' timestamp='1355165575' post='1302925475']
5%, wip, eta eod
[/quote]

[cherlapalli_jailer]

[quote name='mtkr' timestamp='1355164398' post='1302925251']
neeek telisina/chusina links post chei mama..thnx
[/quote]
try swisSQL
30 day free trail
it is very good tool

Here is ur conversion for the function

My advise (with my exp) don't use the tool to convert enter Fun/proc..rather use ut bits and peaces and rest u write that will be more helpful

Here is the sample

/* @(#)C:\SwisSQL\SQLServerToOracle3.5/split_PL.sql - Generated by SwisSQL (SQLServer To oracle) Conversion tool.*/

BEGIN
EXECUTE IMMEDIATE 'DROP TYPE reParsedList0';
EXECUTE IMMEDIATE 'DROP TYPE ParsedList0';
EXCEPTION WHEN OTHERS THEN NULL;
END;
/
CREATE OR REPLACE TYPE ParsedList0 AS OBJECT(value VARCHAR2(4000));
/
CREATE OR REPLACE TYPE reParsedList0 AS TABLE OF ParsedList0;
/
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE fn_SplitList2_TBL CASCADE CONSTRAINTS';
EXCEPTION WHEN OTHERS THEN NULL;
END;
/
CREATE GLOBAL TEMPORARY TABLE fn_SplitList2_TBL(value VARCHAR2(4000)) ON COMMIT PRESERVE ROWS
/
CREATE OR REPLACE FUNCTION fn_SplitList2
(
sList IN OUT VARCHAR2,
sDelim IN VARCHAR2 DEFAULT NULL
)
RETURN reParsedList0 PIPELINED
IS
ParsedList00 ParsedList0:=ParsedList0(NULL);
TYPE REFCURSOR IS REF CURSOR;
CURSOR0 REFCURSOR;

sValue VARCHAR2(4000);
Pos int;
BEGIN
sList := RTRIM(sList) || sDelim;
Pos := INSTR(sList, sDelim, 1);
IF REPLACE(sList, sDelim, '') <> '' THEN
BEGIN
<< LABEL2 >>

WHILE Pos > 0
LOOP
BEGIN
sValue := LTRIM(RTRIM(SUBSTR(sList, 0, Pos -1)));

INSERT INTO fn_SplitList2_TBL
( value )
VALUES ( sValue );
sList := SUBSTR(sList, LENGTH(sList) -LENGTH(RTRIM(sList)) -Pos -LENGTH(RTRIM(sDelim)) + 1 +1, LENGTH(RTRIM(sList)) -Pos -LENGTH(RTRIM(sDelim)) + 1);
Pos := INSTR(sList, sDelim, 1);
OPEN CURSOR0 FOR SELECT * FROM fn_SplitList2_TBL;

END;

END LOOP;
END;
END IF;
RETURN; LOOP
FETCH CURSOR0 INTO
ParsedList00.value;
EXIT WHEN CURSOR0%NOTFOUND;
PIPE ROW(ParsedList00);
END LOOP;
CLOSE CURSOR0;

RETURN;


END;
/

[cherlapalli_jailer]

http://www.swissql.com/products/sqlserver-to-oracle/tsql2plspdownloadform.html

30 day trail down load here

[mtkr]

[quote name='cherlapalli_jailer' timestamp='1355165867' post='1302925526']
[url="http://www.swissql.com/products/sqlserver-to-oracle/tsql2plspdownloadform.html"]http://www.swissql.c...wnloadform.html[/url]

30 day trail down load here
[/quote]


thnx mama....
adi ninna instal chesukunna kani andulo db conns adigindhii...
nt sure whether am on right track r nt... e roju malli chustha..

n thnx fr the abv fn

[chelsea]

[url="http://www.softpedia.com/get/Internet/Servers/Database-Utils/SQL-Server-to-Oracle-Migration-Tool.shtml"]http://www.softpedia...tion-Tool.shtml[/url]

try this ba

[mtkr]

[quote name='chelsea' timestamp='1355168038' post='1302925968']
[url="http://www.softpedia.com/get/Internet/Servers/Database-Utils/SQL-Server-to-Oracle-Migration-Tool.shtml"]http://www.softpedia...tion-Tool.shtml[/url]

try this ba
[/quote]

appice lo access ledu mama a link ki....

[mtkr]

[cherlapalli_jailer]

[quote name='mtkr' timestamp='1355166411' post='1302925632']
thnx mama....
adi ninna instal chesukunna kani andulo db conns adigindhii...
nt sure whether am on right track r nt... e roju malli chustha..

n thnx fr the abv fn
[/quote]


no need to connect to DB

Store ur function in a file and convert

After see ur Q
I downloaded and converted and pasted the result also

Kaani as i suggested complete convertion not advisable..specific conversion and syntax is good

Coz some times those tools take long route to get the solution