Python Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming LanguagesPython Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old September 20th, 2002, 04:25 AM
srk srk is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2002
Posts: 2 srk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
help needed in converting simple python code to oracle plsql

Hi,

I have a very simple and easy python code, and i want to convert it to equivalent oracle plsql code.

The problem is i dont have any idea about the python code at all.

The python code looks like this, how can i convert it to an equivalent oracle plsql code..

Any help is appreciated...

sendnumber={ '123':'8588',
'576':'8899',
'969':'9799' }

def convert_no(sNr_in):
sNo=""
for c in sNr_in:
try:
i = int(c)
sNo = s + c
except:
pass

return sNo


def NormNo(sNr_in):
sNr=string.replace(sNr_in,' ','')
#print "sNr='%s'" %sNr
if sendnumber.has_key(sNr):
return sendnumber[sNr]
elif sNr[0:8]=="01234577":
return "23456"
if not IsNumber(sNr):
return sNr_in
try:
#print "going into provider part"
if int(sNr[-10:-7]) in lst:
sNr_ok = "0044%s" %(sNr[-10:])
elif int(sNr[-11:-8]) in lst:
sNr_ok = "0044%s" %(sNr[-11:])
elif int(sNr[1:4]) in lst:
else:
raise # Telefonnummer mit unbekanntem Format
#print "NormNo from '%s' to '%s'" %(sNr_in, sNr_ok)
return sNr_ok

except:
sErrorString = "SMSStuff.py::NormNo> error in Norm number: %s" %sNr_in
print sErrorString
return sNr_in

def normNrExt(sMSIsdn):
s = convert_no(sdn)
s = NormNo(s)
return s

def isValiddn(sdn):
s = normNrExt(sdn)
if len(s) != 14 and len(s) != 15:
return FALSE
else:
return TRUE



if __name__=="__main__":

#s='0193993999'
s='0045454444444'
s1='94584383883'
s2='34343333329'
s3='445454444450'
s4='3434333343364'

print "NormNo('%s')='%s'" %(s,NormNo(s))
print "NormNo('%s')='%s'" %(s1,NormNo(s1))
print "NormNo('%s')='%s'" %(s2,NormNo(s2))

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming LanguagesPython Programming > help needed in converting simple python code to oracle plsql


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway