Jump to content

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

mtkr

By mtkr
in Old Discussions

 Share

Recommended Posts

mtkr LEGEND

mtkr

Posted
  • Author
Posted

[quote name='lolliman' timestamp='1355193092' post='1302929173']


idi best option anukuntaaa baaa... try this one
[/quote]


seems like its wrkng lle bit....
kani em ardam aithaledhuuu.... parameters n sp name ki kuda nt recognized antundhiiii!!!

  • Replies 80
  • Created
  • Last Reply

Top Posters In This Topic

  • mtkr

    38

  • iTeachSAP

    13

  • Ka NTR i

    5

  • cherlapalli_jailer

    5

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

mtkr
mtkr

[quote name='mrudhula99' timestamp='1355194163' post='1302929252'] nakem radhu mtkr.. naku kuda stored proc nerchukovalani undhiii.. ee thread bookmark cheskunnaa... malli nenu edho oka coomen

mtkr LEGEND

mtkr

Posted
  • Author
Posted

[quote name='mrudhula99' timestamp='1355194163' post='1302929252']
nakem radhu mtkr..

naku kuda stored proc nerchukovalani undhiii.. ee thread bookmark cheskunnaa...

malli nenu edho oka cooment cheyyaganee comedy chestharu... spamming start ayyedhiii.. andhukee em cheppatledhu.... $s@d $s@d


job vcahindhaa????
[/quote]
anduke e thippal...

[quote name='Silver_mani' timestamp='1355197033' post='1302929491']
iTeachSAP CITI_$D# CITI_$D#
[/quote]
sHa_clap4

  • Upvote 1
Silver_mani LEGEND

Silver_mani

Posted
Posted

[quote name='mtkr' timestamp='1355198347' post='1302929591']
anduke e thippal...


sHa_clap4
[/quote]
[img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmilaugh.gif[/img][img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmilaugh.gif[/img][img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmilaugh.gif[/img]

Ka NTR i Hero

Ka NTR i

Posted
Posted

[quote name='mtkr' timestamp='1355198253' post='1302929583']


seems like its wrkng lle bit....
kani em ardam aithaledhuuu.... parameters n sp name ki kuda nt recognized antundhiiii!!!
[/quote]

first nuvvu stored proc nee schema lo create cheyaali mama.. then you need to run it. My guess nuvvu as it is ga run chesthunatlundhi..... nee converted Pl/SQL code post chei... i could help you.

iTeachSAP Celebrity

iTeachSAP

Posted
Posted

bayya... sorry bayya... sap abap , bi bw , bo 4.0 setup petinam new servers ... danamma installation 16 hours pattindhi...

ni issue resolved aa ?

mtkr LEGEND

mtkr

Posted
  • Author
Posted

[quote name='BlueBerry' timestamp='1355198515' post='1302929605']

first nuvvu stored proc nee schema lo create cheyaali mama.. then you need to run it. My guess nuvvu as it is ga run chesthunatlundhi..... nee converted Pl/SQL code post chei... i could help you.
[/quote]
only frst block ki try chesaaa....



[CODE]
--SQLDEV:Following Line Not Recognized
CREATE PROCEDURE rsp_Application_Audit_Process
--SQLDEV:Following Line Not Recognized
@Channel Varchar(40),
--SQLDEV:Following Line Not Recognized
@StartDate datetime

BEGIN
AS_(BEGIN_) ;
END;
SELECT *
FROM DUAL ;
--SQLDEV:Following Line Not Recognized
from (

BEGIN
SELECT_('Application Not Received from Siebel') ;
END;

BEGIN
Channel(aa.HIC,
se.medicare_no,
aa.ReceiveDate,
aa.LastName,
se.last_name) ;
END;

BEGIN
FirstName(se.first_name) ;
END;

BEGIN
ADDRESS(aa.City,
aa.STATE,
aa.Zip,
aa.Phone,
aa.SSN,
aa.DOB,
se.date_of_birth) ;
END;

BEGIN
EffectiveDate(se.application_id,
se.subscriber_id,
se.hcc_id,
se.cip_id,
SUBSTR(aa.FILENAME, 69, 20)) ;
END;

BEGIN
confirmation_number(' ') ;
END;

BEGIN
Application_Source('MA') ;
END;

BEGIN
FROM_(appaudit) ;
END;

BEGIN
LEFT(JOIN) ;
END;
--SQLDEV:Following Line Not Recognized
where se.confirmation_number is null
--SQLDEV:Following Line Not Recognized
and aa.channel = 'CMS'
--SQLDEV:Following Line Not Recognized
and aa.channel IN (SELECT * FROM dbo.fn_SplitList2(@Channel,','))
--SQLDEV:Following Line Not Recognized
and aa.Invalid = 'N'
--SQLDEV:Following Line Not Recognized
and( (@StartDate is null) or (aa.ReceiveDateTime >= @StartDate))
--SQLDEV:Following Line Not Recognized
and aa.HIC not in (select HIC from AppAudit aa1 inner join vw_stage_enrollment_cms se1 on aa1.HIC = se1.medicare_no wherese1.medicare_no is null and aa1.channel='CMS')
--SQLDEV:Following Line Not Recognized
)a
--SQLDEV:Following Line Not Recognized
end
[/CODE][quote name='BlueBerry' timestamp='1355198515' post='1302929605']

first nuvvu stored proc nee schema lo create cheyaali mama.. then you need to run it. My guess nuvvu as it is ga run chesthunatlundhi..... nee converted Pl/SQL code post chei... i could help you.
[/quote]

mtkr LEGEND

mtkr

Posted
  • Author
Posted

[quote name='Silver_mani' timestamp='1355198454' post='1302929598']
[img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmilaugh.gif[/img][img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmilaugh.gif[/img][img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmilaugh.gif[/img]
[/quote]
neek enti maayaa... tees mar khan viiii

[quote name='BlueBerry' timestamp='1355198515' post='1302929605']

first nuvvu stored proc nee schema lo create cheyaali mama.. then you need to run it. My guess nuvvu as it is ga run chesthunatlundhi..... nee converted Pl/SQL code post chei... i could help you.
[/quote]
creation aaa!!!?
assal manam ikkada db ki connect e avvadam led ga mama... malli creation Y??

[quote name='iTeachSAP' timestamp='1355198686' post='1302929620']
bayya... sorry bayya... sap abap , bi bw , bo 4.0 setup petinam new servers ... danamma installation 16 hours pattindhi...

ni issue resolved aa ?
[/quote]

srry Y mama.... lite........
resolved aaa ante inka tryng

Ka NTR i Hero

Ka NTR i

Posted
Posted

[quote name='mtkr' timestamp='1355198887' post='1302929635']
only frst block ki try chesaaa....



[CODE]
--SQLDEV:Following Line Not Recognized
CREATE PROCEDURE rsp_Application_Audit_Process
--SQLDEV:Following Line Not Recognized
@Channel Varchar(40),
--SQLDEV:Following Line Not Recognized
@StartDate datetime

BEGIN
AS_(BEGIN_) ;
END;
SELECT *
FROM DUAL ;
--SQLDEV:Following Line Not Recognized
from (

BEGIN
SELECT_('Application Not Received from Siebel') ;
END;

BEGIN
Channel(aa.HIC,
se.medicare_no,
aa.ReceiveDate,
aa.LastName,
se.last_name) ;
END;

BEGIN
FirstName(se.first_name) ;
END;

BEGIN
ADDRESS(aa.City,
aa.STATE,
aa.Zip,
aa.Phone,
aa.SSN,
aa.DOB,
se.date_of_birth) ;
END;

BEGIN
EffectiveDate(se.application_id,
se.subscriber_id,
se.hcc_id,
se.cip_id,
SUBSTR(aa.FILENAME, 69, 20)) ;
END;

BEGIN
confirmation_number(' ') ;
END;

BEGIN
Application_Source('MA') ;
END;

BEGIN
FROM_(appaudit) ;
END;

BEGIN
LEFT(JOIN) ;
END;
--SQLDEV:Following Line Not Recognized
where se.confirmation_number is null
--SQLDEV:Following Line Not Recognized
and aa.channel = 'CMS'
--SQLDEV:Following Line Not Recognized
and aa.channel IN (SELECT * FROM dbo.fn_SplitList2(@Channel,','))
--SQLDEV:Following Line Not Recognized
and aa.Invalid = 'N'
--SQLDEV:Following Line Not Recognized
and( (@StartDate is null) or (aa.ReceiveDateTime >= @StartDate))
--SQLDEV:Following Line Not Recognized
and aa.HIC not in (select HIC from AppAudit aa1 inner join vw_stage_enrollment_cms se1 on aa1.HIC = se1.medicare_no wherese1.medicare_no is null and aa1.channel='CMS')
--SQLDEV:Following Line Not Recognized
)a
--SQLDEV:Following Line Not Recognized
end
[/CODE]
[/quote]
Nuvvu just nerchukuntunaava? leka Project lo taska idhi?

mtkr LEGEND

mtkr

Posted
  • Author
Posted

[quote name='BlueBerry' timestamp='1355201612' post='1302929838']
Nuvvu just nerchukuntunaava? leka Project lo taska idhi?
[/quote]

task...

mtkr LEGEND

mtkr

Posted
  • Author
Posted

[quote name='ANBESHIVAM' timestamp='1355204456' post='1302929971']
CITI#H@ ltt
[/quote]
thnx maayaaa... lv u

ANBESHIVAM Hero

ANBESHIVAM

Posted
Posted

[quote name='mtkr' timestamp='1355205025' post='1302929990']
thnx maayaaa... lv u
[/quote]
:D

mtkr LEGEND

mtkr

Posted
  • Author
Posted

kindi nundi partlu partlu ga execute chesukuntu pothe idi ochindiii


[CODE]

CREATE OR REPLACE PROCEDURE sp_newthing
(
v_channel IN VARCHAR2 DEFAULT NULL ,
v_startdate IN DATE DEFAULT NULL ,
cv_1 OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN cv_1 FOR
SELECT *
FROM ( SELECT aa.Channel ,
aa.HIC ,
se.medicare_no ,
aa.ReceiveDate ,
aa.LastName ,
se.last_name SMM_LastName ,
aa.FirstName ,
se.first_name SMM_FirstName ,
aa.ADDRESS ,
aa.City ,
aa.STATE ,
aa.Zip ,
aa.Phone ,
aa.SSN ,
aa.DOB ,
se.date_of_birth SMM_DOB ,
aa.EffectiveDate ,
se.application_id ,
se.subscriber_id ,
se.hcc_id ,
se.cip_id ,
SUBSTR(aa.FILENAME, 69, 20) FILENAME ,
aa.confirmation_number ,
' ' DCN ,
aa.Application_Source ,
'MA' product_type
FROM appaudit aa
LEFT JOIN vw_stage_enrollment_cms se
ON aa.confirmation_number = se.confirmation_number
WHERE se.confirmation_number IS NULL
AND aa.channel = 'CMS'
AND aa.channel IN ( SELECT *
FROM TABLE(fn_SplitList2(v_Channel, ',')) )
AND aa.Invalid = 'N'
AND ( ( v_StartDate IS NULL )
OR ( aa.ReceiveDateTime >= v_StartDate ) )
AND aa.HIC NOT IN ( SELECT HIC
FROM AppAudit aa1
JOIN vw_stage_enrollment_cms se1
ON aa1.HIC = se1.medicare_no
WHERE se1.medicare_no IS NULL
AND aa1.channel = 'CMS' )
) a ;
END;
[/CODE]

mtkr LEGEND

mtkr

Posted
  • Author
Posted

thnx blueberry n lolli mama for tool....

repu mrng exec chesi chudaaalii res's

Ka NTR i Hero

Ka NTR i

Posted
Posted

[quote name='mtkr' timestamp='1355205282' post='1302929997']
thnx blueberry n lolli mama for tool....

repu mrng exec chesi chudaaalii res's
[/quote]
Np mama.. repu morning konchem free vuntaa... emina doubts vunte...taadu lepu... ledha PM chei... work out chedhaam

 Share
Go to topic listing
×
×
  • Create New...