Limitation in dbms_output.put_line in pl/sql

by Vahid 18. February 2009 10:32
Today I was testing a function in pl/sql using pl/sql developer. In the function we are contenting so many strings that the leng of the final string would go more than 4000. As usual I was trying to use dbms_output.put_line to debug the function and make sure the end result is ok. But at the end of the function when I was trying to print the final string using this function I was not  getting the expected result. the string was being truncated. First I thought there is a problem with varchar2(4000) data type which I had declared for my variable. So I changed the data type to LONG which can hold unto 2GB of data. But still the same issue was there.Spending sometimes on the issue I thought there may be some limitation to the put_line function. So I created a temporary table with a single clob column and inserted the final string into that column instead of printing to out window. Surprisingly it worked properly and I was able to see the whole string from the column. Doing some R&D on this I came to know that dbms_output.put_line() function has just a buffer of 2000 characters and it will only print 2000 chars. I was not able to find out any way to increase this buffer size but once I find it, I’ll write about it. 


Tags: , ,


Customizing Entity Framework Classes in VS 2010

by Vahid 17. February 2009 15:32

 need to know about new cool features in visual studio 2010? check this link which describes new features for entity framwork in vs 2010

Tags: ,

.Net | Learning resource | Technical

Entity Framework learning resouce

by Vahid 17. February 2009 15:17

browsing internet i found this document about entity framework which comes with microsoft .net framework 3.5 sp1.

check it out at:





.Net | Learning resource | Technical

Windows Azure, The future platform of most of us

by Vahid 17. February 2009 13:30


What is the Azure Services Platform?

he Azure™ Services Platform (Azure) is an internet-scale cloud services platform hosted in Microsoft data centers, which provides an operating system and a set of developer services that can be used individually or together. Azure’s flexible and interoperable platform can be used to build new applications to run from the cloud or enhance existing applications with cloud-based capabilities. Its open architecture gives developers the choice to build web applications, applications running on connected devices, PCs, servers, or hybrid solutions offering the best of online and on-premises.


Windows Azure

Windows® Azure is a cloud services operating system that serves as the development, service hosting and service management environment for the Azure Services Platform. Windows Azure provides developers with on-demand compute and storage to host, scale, and manage internet or cloud applications. Windows Azure supports a consistent development experience through its integration with Visual Studio. In the early stages of CTP, .NET managed applications built using Visual Studio will be supported. Windows Azure is an open platform that will support both Microsoft and non-Microsoft languages and environments. Windows Azure welcomes third party tools and languages such as Eclipse, Ruby, PHP, and Python.



.Net | Technical

یک حقیقت درباره ما ایرانیان

by Vahid 13. February 2009 04:25

مرتضي مطهری در کتاب حق و باطل جملاتی به این مضمون نوشته اند :

از کودکی همیشه این سوال برایم مطرح بود که : چرا قطار تا وقتی ایستاده است کسی به او سنگ نمی زند؟ اما وقتی قطار به راه افتاد سنگباران می شود؟

این معما برایم بود تا وقتی که بزرگ شدم و وارد اجتماع شدم دیدم این‏ قانون کلی زندگی ما ایرانیان است که هر کسی و هر چیزی تا وقتی که ساکن‏ است مورد احترام است. تا ساکت است مورد تعظیم و تبجیل است اما همینکه به راه افتاد و یک قدم برداشت نه تنها کسی کمکش نمی‏کند ، بلکه‏ سنگ است که بطرف او پرتاب می‏شود و این نشانه یک جامعه مرده است ولی یک جامعه زنده فقط برای کسانی احترام قائل است که : متکلم هستند نه‏ ساکت ، متحرکند نه ساکن ، باخبرترند نه بی‏خبرتر .


Persian | General

This is called CAR

by Vahid 11. February 2009 06:02

look at this Mercedes Benz SLR whose body is fully white gold. the pictures have been taken in the Mall of emirates in Dubai.

Benz SLR - White Gold 1 Benz SLR - White Gold 2 Benz SLR - White Gold 3



Extreme WCF Training Video

by Vahid 10. February 2009 13:46


if you have been working with Windows communication foundation and you still don’t know how to organize your layers in a very good way, you have to check this out. in this video of DNRTV Miguel Castro shows us how to get the best out of Windows Communication Foundation. Miguel extholls the virtues of doing WCF projects from scratch, and not using the Visual Studio templates.  you can get/watch the video from the following link

Technorati Tags:


.Net | Learning resource | Technical

Marriage Facts… Enjoy

by Vahid 4. February 2009 03:41

When a man steals your wife, there is no better revenge than to let him keep her.
David Bissonette

After marriage, husband and wife  become two sides of a coin; they just can't face each other, but still they stay together.
Sacha Guitry

By all means marry. If you get a good wife, you'll be happy. If you get a bad one, you'll become a philosopher.

Woman inspires us to great things, and prevents us from achieving them.

The great question... which I have not been able to answer... is, 'What does a woman want?

I had some words with my wife, and she had some paragraphs with me.
Sigmund Freud

'Some people ask the secret of our long marriage. We take time to go to a restaurant two times a week. A little candlelight, dinner, soft music and dancing. She goes Tuesdays, I go Fridays.'

'There's a way of transferring funds that is even faster than electronic banking. It's called marriage.'
Sam Kinison

'I've had bad luck with both my wives. The first one left me, and the second one didn't.'
James Holt McGavra

Two secrets to keep your marriage brimming
1. Whenever you're wrong, admit it,
Whenever you're right, shut up.
Patrick Murra

The most effective way to remember your wife's birthday is to forget it once....

You know what I did before I married? Anything I wanted to.

My wife and I were happy for twenty years. Then we met.
Henny Youngman

A good wife always forgives her husband when she's wrong..
Rodney Dangerfield

A man inserted an 'ad' in the classifieds: 'Wife wanted'.. Next day he received a hundred letters. They all said the same thing: 'You can have mine.'

Questions and Answers

First Guy (proudly): 'My wife's an angel!'
Second Guy: 'You're lucky, mine's still alive.'


General | Personal

Steve Jobs speech. you must watch twice a day

by Vahid 3. February 2009 16:07

Here we see Steve Jobs delivering his commencement speech to the graduates of Stanford University in 2005.

You should watch this video at least twice a day. Steve gives such an impressive speech which is full of nice, fantastic and useful advices.


Technorati Tags:



PointUI, a fancy UI for windows moible

by Vahid 1. February 2009 18:21

i just installed PointUI on my pocket pc and loved it. it's an alternative fancy UI for windows mobile. if you got a pocket pc you should try it. you can download it at

here are some snap shots :


Tags: ,