Monday, August 17, 2009

My success story in RTO Chennai without single penny bribe!

This is post which I wanted to write for long time, but I did not do because of my laziness!
I had a two wheeler which was bought in Pune when I was working in pune. So it's was registered for maharatra (MH) state. I did not realize the registration change how difficult it is. After served couple of year in pune, I had come to Chennai. I got the NOC (No Object Certificate) the moment I left pune. NOC is mandatory for re-registration whenever we go a state to state.
I enquired with couple of travels agency to change about re-registration of my vehicle. All are asked 4k – 5 k bucks. I then though why don't I myself go to RTO and apply for re-registration as I had NOC in my hand. I searched on internet and gathered RTO tamilnadu procedure for re-registration and ended up with a site
http://www.tn.gov.in/sta/eng%20cc/rc9.html which had given require documents and fees structure. I just amazed the re-registration fees was just Rs 60 for two wheeler. But the road tax was around R.s 1800 and other charges and late payment fees. I went to RTO office in Chennai and cached a person who works in RTO. I asked what I need to do to get re-registration certificate. He said that I would need to get Police clearance certificate first, then you come to RTO with all necessary document.
I then had gone to Commissioner Office, Egmore Chennai. I did not know anybody over there and it was first time that I was entering into a police environment. Finally, I reached a section in which I could get the police clearance certificate. I had given the necessary document to them and they asked me to come next day and collected the police certificate next day with out any trouble!
Having police certification and all required documents in hand, I had gone to RTO office. Initially, I did not know where I have to start and whom I have to contact. All people were in RTO wondering here and there. No body was giving proper response. Finally, men told me that go and meet RTO and he would guide me. I then met RTO officer and I kept the document with out any order and my goodness, he himself arranged all documents and kept them perfectly. He signed in a form of that file, and asked me to go and meet B1 section. I had gone there and met a lady and she said that I need to go and meet vehicle inspector for the first inspection.
I then met vehicle inspector and he said that I would have to bring the bike the ground where they used to inspect all the vehicles. I thought they might expect some bribe in the ground. Same time I was thinking not to bribe for any extend. I had gone to ground and shown my vehicle, they asked me to take the pencil shadow of chassis and engine numbers in a form and I did the same thing and inspector had signed a form and he asked me to come to RTO office again. I then went to RTO office again and managed to meet him and he signed again in another form and asked me to pay the Road tax. Initially, they refused to pay road tax and they given the time frame that I could pay road tax only with in the time frame. I got irritated and asked why. They said that’s the way it is. Then I did not give up and finally I managed to pay my road tax. I then gone to B1 section and next day they had given copy of the letter which suppose to be sent to pune RTO office stating to enquire about this vehicle. That B1 section people told me that it takes lot of time to get the back the reply from Pune , RTO office and they said it may take 6 months time to see their reply. I said that that's okay and taken the copy of the letter which can be used for 1 year while bike riding.
A year later, I had gone to same RTO office and asked whether they received any reply from Pune, RTO. They said yes and asked me to inspect the bike for second inspection which is part of the procedure. I then gone for the ground and waited for some time and inspection done and got the vehicle inspector's sign. I then paid re registration fees Rs 60 and approached B1 section people. They said that it takes two day to get new number. I was happy that I could get my new number in two days.
I then gone RTO and got the new number without single penny bribe! :)-
My overall experience:
(1) Its possible to handle the government officers with out bribe
(2) It was little difficult in RTO office that whom to contact for what. To know this, it took two days for me :)-
(3) Since my office timing start only in noon, I could go RTO office morning and came back office the noon time. I wonder it may not easy , if we go office regular timing like 9 – 6
(4) I would have gone to RTO 10 times at least for entire process
(5) Actually, procedure was very simple, but the way RTO employees handling the procedure will make the things difficult.
(6) Don’t give bribe as long as you have correct documents though government employees delay the process in a way.
(7) You have to be ready to stand in RTO hours and hours!
(8) Have all necessary documents in your hand then go to RTO. It would avoid time consuming.


My unanswered question:


Why separate registration for state to state since all of them under India? I understand RTO controlled by state government. But why can't central government taken control of all RTO and avoid all these things. I
I paid life time road tax in pune and again paid in Chennai. Then what's was use for the bucks I paid in Pune RTO?
Perhaps, since this is the good earning for state government, how they would stop this!

Thursday, August 13, 2009

Ego Illyaraja?

It's happened to see a song in Tamil channels when I was rotating the TV channels one day. Music directory Illayaraja was appearing in the on screen and singing a song in a Tamil movie called "Azhkar Malai". I was just surprise to see Illayaraja in on-screen. But my surprise turned out as frustration! Yeah, that particular song starts like this…


uzhagam ippo enga poguthuennaku intha annai boomi pothumingu pirantharavum engai pogirarennaku intha sontha naadu pothumintha mannai vittu naan engai selvain
…………………………………………………………..


Means... World goes some where! , but my mother land is enough for me! . For me my country is enough! Where else I could go from my born place!
This song intended to mean A.R Rahman . Raja composed this song after A.R.R just got Oscar and few global awards. It shows that Raja is having ego with A.R.R. I don't know the exact reason. But from this song he composed, clearly says that he criticize A.R.R. Is it because of Raja's popularity had come down since A.R.R started to compose? Rahman never replied on remarks made against him. He is down to earth and humble and good human being!
Now a day, Raja is composing for all 'B' grade movies since he doest not have much movies as he used to get before! Is that frustration made Raja to comment on Rahman?
As long as Raja comment on A.R.R, Rahman will go further height! I consider Raja is still doing Bachelor degree in music! Rahman doing his Ph. D in music! I also fan of Raja but when he does it like this, it's frustrating!
People will love Raja for his music but world never admires Raja personally. Same time, people will admire Rahman for his music and clean personal life! Jai Ho, Thala A.R.R!

Die heart fan of A.R.Rahman!
Thambi

Oracle OLE property OraDatabase.LastServerErrText message capturing issue in VB 6.0

Hi,
I have an application which uses Oracle 9i and Visual Basic 6.0 (Front end). I am passing a user defined text message by using raise_application_error (-20700, error_desc) from Oracle 9i to Visual Basic 6.0. Here, Oracle may send up to 10000 characters to Visual Basic front end. I am capturing oracle error message (raised by raise_application_error procedure) in Visual Basic in below way i.e.
My Question:
-- Session creationSet OraSession = CreateObject ("OracleInProcServer.XOraSession")Set OraDatabase = OraSession.dbopendatabase(UserID.sOraSecDB, "XXXXX/XXXXX", 0&)

.
.
Public Sub Validate (dbConnection As Object, TSRPData As datTSRP_Record)
On Error GoTo ErrorGoTo StartError:sysError.HandleOracleError Err.Number, dbConnection
Resume throw_up
throw_up:
On Error GoTo 0
sysError.Raise
Start:
.
.
'Invoke Stored Procedure to validate the VCA of the Timed SRP
sSQL = "begin PA_ATD_ATS.PR_VALIDATE_TSRP (:pnTim_Srp_Id); end;"
.dbexecutesql sSQL
.
.
End Sub
After running above procedure PR_VALIDATE_TSRP, raise_application_error procedure will returns the error text message which is captured by user defined method "HandleOracleError"
Public Sub HandleOracleError (ErrNum As Variant, OraDatabase As Object)

If ErrNum = 440 Then
'OLE Error - i.e. Oracle Objects
ErrorovnSysErrorNumber = OraDatabase.LastServer
ErrovsSysErrorText = OraDatabase.LastServerErrText
End If
End Sub
In the above user defined method, OraDatabase.LastServerErrText captures only 532 characters. If raise_application_error returns more than 532 characters in the sense, OraDatabase.LastServerErrText captures only 532 characters and rest of characters are truncated. Please remember above coding is working fine. My only issue is that error truncation i.e OraDatabase.LastServerErrText not capturing more than 532 characters, and when I try in debug mode, if I try to print Err.description value after running PA_ATD_ATS.PR_VALIDATE_TSRP , it's also not capturing more than 532 characters. I guess OLE error object's LastServerErrText property NOT able to capture more than 532 characters. When I look at the LastServerErrText in oracle documentation , I don't see any limit is specified for method OraDatabase.LastServerErrText (
http://download.oracle.com/docs/cd/B19306_01/win.102/b14309/serprop.htm#CHDIBDGF )Is there any limit OLD object LastServerErrText can capture only this much characters ( 532 characters)?, and Please guide me how i can make the adjustment to capture more than 532 characters by using same OLE object method. My user looking to see at least 10,000 characters, he does not want to see that error message truncation.
Regards,
Thambi
I have got the reply from Guru of that forum as below :

Hi,
I tested 11g, and see 511 as the max. I'd assume this is an undocumented limitation of LastServerErrText, as I wasn't able to find it in the docs. Although it seems odd to me that you'd want to return that much data in an error message, if you have a requirement for that you might consider storing the data in a table instead, and querying the table after receiving notification of the problem.
Hope it helps
Greg
My final reply is:
Yes, I created error table and loaded the error message into it. It does work. Thanks a lot for your help but I am still surprised that oradatabase.LastServerErrText property is not allowing more than 532 characters
Regards,
Thambi