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

[mtkr]

[iTeachSAP]

ipudu nannu emi cheyamantaavoo cheppu ? error fix cheyala ? ee block error vasthundhoo ... ikkada veyi .. i liost in the middle...

[mtkr]

[quote name='iTeachSAP' timestamp='1355327522' post='1302938207']
ipudu nannu emi cheyamantaavoo cheppu ? error fix cheyala ? ee block error vasthundhoo ... ikkada veyi .. i liost in the middle...
[/quote]


antha solved bayya...

jus proc ni sql navi'gator lo ela exec cheyyalo chepthe happiess...

proc ni report lo use chesthe o/p ostundhii... kani navi lo ela execute cheyyalo theleyadam led

Thnx

[iTeachSAP]

[quote name='mtkr' timestamp='1355328749' post='1302938298']
antha solved bayya...

jus proc ni sql navi'gator lo ela exec cheyyalo chepthe happiess...

proc ni report lo use chesthe o/p ostundhii... kani navi lo ela execute cheyyalo theleyadam led

Thnx
[/quote]

idhi work avatam ledha ?

[font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000]EXECUTE[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][font=Courier New][size=2][color=#000000] sp_newprocedure[/color][/size][/font][/size][/font][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000]([/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080]'acs,cms,'[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000],[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080]'12-10-2010'[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000]);[/color][/size][/font][/color][/size][/font][/color][/size][/font]

ni number of passing parameters has to be same as that you have declared at proc.

aa third parameter out parameter ayithe , you dont need to pass....

[mtkr]

[quote name='iTeachSAP' timestamp='1355330197' post='1302938451']

idhi work avatam ledha ?

[font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000]EXECUTE[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][font=Courier New][size=2][color=#000000] sp_newprocedure[/color][/size][/font][/size][/font][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000]([/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080]'acs,cms,'[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000],[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080][font=Courier New][size=2][color=#008080]'12-10-2010'[/color][/size][/font][/color][/size][/font][/color][/size][/font][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000][font=Courier New][size=2][color=#ff0000]);[/color][/size][/font][/color][/size][/font][/color][/size][/font]

ni number of passing parameters has to be same as that you have declared at proc.

aa third parameter out parameter ayithe , you dont need to pass....
[/quote]


Error vastundhiii


[1]: ORA-06550: line 1, column 7:
[1]: PLS-00306: wrong number or types of arguments in call to 'SP_NEWPROCEDURE'
[2]: ORA-06550: line 1, column 7:
[2]: PL/SQL: Statement ignored

[iTeachSAP]

[quote name='mtkr' timestamp='1355330543' post='1302938491']


Error vastundhiii


[1]: ORA-06550: line 1, column 7:
[1]: PLS-00306: wrong number or types of arguments in call to 'SP_NEWPROCEDURE'
[2]: ORA-06550: line 1, column 7:
[2]: PL/SQL: Statement ignored
[/quote]


mama login ayi chudalisindhe... tvaraga issue solve avuthundhi ...