| Pl/sql [message #340214] |
Tue, 12 August 2008 00:28  |
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
|
Member |
|
|
Hi all,
I am not much proficient in pl/sql but my company has asked me to read some books and get trained in pl/sql. So i went through a book by an author named Scott Urman.
They say that i would be required to do some function or procedure troubleshooting. I am not proficient in troubleshooting but i was able to grab the pl/sql programming concepts. I just wanted to know if there are any books or documents that might guide me in Function or procedure troubleshooting?? Pls let me know. Also it will be helpful if anyone can brief me about what function trouble shooting is all about?
Thanks,
Arun.
|
|
|
|
| Re: Pl/sql [message #340223 is a reply to message #340214] |
Tue, 12 August 2008 00:55  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
The best way to learn this and any programming language or technique is by having a tutor.
Is there anyone in your company that is a senior PL/SQL programmer or DBA who you can ask to tutor you? If not, see if there is any senior programmer in another language; after all, programming techniques really don't differ that much, especially the ideas behind debugging and such.
I think it is nearly impossible to learn this from a book. Only experience can help you, and, to become really good at it, you have to have a certain 'je ne sais quoi'.
|
|
|
|
|
|
| Re: Pl/sql [message #340237 is a reply to message #340223] |
Tue, 12 August 2008 01:14 |
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
|
Member |
|
|
Hi Frank! Thanks for the reply. Well i am the only Oracle DBA here. But there is one Senior Data Analyst in our company for SQL Server database. So, will he be able to assist me?
P.S: (Are there any stereotyped problems that needs trouble shooting in pl/sql, which occur quite often?? If so is it possible for you to list them?)
Thank you,
Arun.
|
|
|
|
|
|
| Re: Pl/sql [message #340246 is a reply to message #340237] |
Tue, 12 August 2008 01:38 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
If there is noone else available, go with the SQLServer guy to learn techniques on how to tackle a problem.
Depending on how good this guy is (whether or not he knows the consequences of the differences between SQLServer and Oracle), you should be very careful to following his advise on how to rewrite stuff though..
The problems that occur most depend greatly on the level of the developer(s) that initially built the system.
Speaking of which.. what happened to him/them? Are they no longer around to help you?
|
|
|
|
| Re: Pl/sql [message #340259 is a reply to message #340246] |
Tue, 12 August 2008 02:10 |
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
|
Member |
|
|
Hi Frank,
Actually there are no developers right here, all are in the US at the client's location,they have forwarded the DBA activities alone to our company. My client used to interact with me thro online chat to guide me with his requirements.
|
|
|
|
| Re: Pl/sql [message #340274 is a reply to message #340259] |
Tue, 12 August 2008 03:17 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
But then you should not be the one responsible for debugging PL/SQL code..
Not that you should not learn, after all, it is a fun thing to do.
|
|
|
|
| Re: Pl/sql [message #340283 is a reply to message #340274] |
Tue, 12 August 2008 03:33 |
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
|
Member |
|
|
Ok Frank, i will do as u said.. well ....hope u'll help me out during crisis situations...
Thanks,
Arun.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
]