frm - 40039 can’t attach PL/SQL Library

January 2nd, 2010 admin No comments

very common error while testing and compile oracle form 60 forms

Solution is simple make a common folder for library file for example in my case i make a folder e:\lib. and placed all common libraries with .llb and llx there, open windows registry by typing regedit at run on start menu. go to software tag/key and open oracle home there you fine a key name with FORMS90_PATH or FORMS60_PATH. add the path there like
C:\orant\TOOLS\OPEN60\PLSQLLIB;e:\Lib;
open form and attached library from there and compile and run the form problem will resolve

Categories: pl sql Tags:

Kahan ho tum chalay aao, mohabbat ka taqaza hai

December 14th, 2009 admin No comments

A nice poem sung by nayyar noor wisper in my mind,

Kahan ho tum chalay aao, mohabbat ka taqaza hai
Dhum-e-dunya say ghabra kur tumhein di nay pukara hai

Tumhari be-rukhi aik din hamari jaan le lay gi
Qasm tum ko, zara sochu dastoor-e-wafa kia hai

Na janay kis liye dunya ki nazrein phit gayeen hum say
Tumhein dekha tumhein chaha qasoos is kay siwa kia hai

Categories: poetry Tags:

Top n Values with Linq to Sql

November 14th, 2009 admin No comments

Hi all  very simple problem i was facing while playing with linq to sql. I handle it though  with this simple. I expect you already working with linq to sql to to the point it as

WallpaperDataDataContext _Context = new WallpaperDataDataContext();
string _Sql = ” select top 5 * from tblImages order by posteddate desc “;
IEnumerable<tblImage> _ListIMage = _Context.ExecuteQuery<tblImage>( _Sql );

While tblImage is table in database in my working database schema

Categories: Asp.net, Linq to sql, c# Tags:

how to insert data using cursor in PL/SQL

September 18th, 2009 admin No comments

Being a .net technologies guy I never be go on database level. but last night I have to face a small problem . I have to done 50000 record entries in one of table with relation to parent table. I used Pl Sql cursor. You already know much about Cursor they exists both in Oracle and Sql server and even My Sql. Following is a solution of insertion
Using Cusros so I insert 50000  in child table with respect to parent table..

DECLARE

/* Output variables to hold the result of the query: */

a Teacher.teacher_code %TYPE;

/* Cursor declaration: */

CURSOR T1Cursor IS
SELECT teacher_Code

FROM Teacher

FOR UPDATE;

BEGIN

OPEN T1Cursor;

LOOP

/* Retrieve each row of the result of the above query

into PL/SQL variables: */

FETCH T1Cursor INTO a;

/* If there are no more rows to fetch, exit the loop: */

EXIT WHEN T1Cursor%NOTFOUND;

/* Delete the current tuple: */

/* Insert the reverse tuple: */

INSERT INTO Teacher_ChildTable (Teacher_code,Class_code,Teaching_Mode,Period)    VALUES(a,’0324′,’01′,450);

END LOOP;

/* Free cursor used by the query. */

CLOSE T1Cursor;

END;

Have a nice day.

Categories: pl sql Tags:

Best advice for your preparation for 70-536

September 4th, 2009 admin No comments

As is known to everyone, if you learn and master each and every aspect of the subject and get a hand on experience on it, and then you will not have any problems, that is to say, you absolutely will get 70-536!!But, we could not become a master in .net framework-application Development Foundation in singe half year or one year.

When you read it here, maybe you’ll be confused and ask how the candidate for MCTS 70-536 could make it in a couple of months?? Of course, we can make it if you follow the steps as this article said below:

To pass the exams, the 70-536 candidates should firstly focus on important areas. So, you should pay attention to the official site since the guideline is subject to change at any time without prior notice and at the sole discretion of Microsoft. Generally speaking, there won’t be substantial change.

Here is the guide for 70-536:

1. Developing applications that use system types and collections (15 percent)

2. Implementing service processes, threading, and application domains in a .NET Framework application (11 percent)

3. Embedding configuration, diagnostic, management, and installation features into a .NET Framework application (14 percent)

4. Implementing serialization and input/output functionality in a .NET Framework application (18 percent)

5. Improving the security of .NET Framework applications by using the .NET Framework security features (20 percent)

6. Implementing interoperability, reflection, and mailing functionality in a .NET Framework application (11 percent)

7. Implementing globalization, drawing, and text manipulation functionality in a .NET Framework application (11 percent)

Of course, the detail information won’t be listed; however, it could help us decide how much time we should spend in each major topic area according to the relative weight on the exam.

So, we have known what object we’ll achieve, and then we should have the best materials for us to prepare 70-536.

1. Good online training websites. They can provider many resources for us to better know the objectives and better prepare the exams. All Microsoft exams have a set of objectives outlining the topics you need to understand to become successful in the exam. It is a good practice to visit the Microsoft’s site to check the latest exam details, because these objectives keep on changing from time to time.

2. Outstanding software that really trains for this exam.

3. Good books .Here is the two books. Step by step book which I would recommend you to start with:

1. The Microsoft Certified Application Specialist Study Guide

2. MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Foundation

So, after all preparations are done, we need to make a plan to prepare the exam!!! The following plan is just for your reference, and you should find the best suit for yourself.

1. Fix your daily hours of study and set a deadline for completing the entire contents. This will help you prepare efficiently for the exam.

2. Once you have created your study plan, you should attempt the diagnostic tests, and you should concentrate your studies on these objectives, as a thorough knowledge of the topics included in them is essential for passing the exam.

3. Study Notes: The Study notes are organized according to the actual test objectives. It helps you understand the topics clearly and systematically, assist you in difficult areas and organize your studies. They provide in-depth knowledge of different topics and help you become a master in the respective field.

4. Practice questions are necessary to get an overview on the type of questions you will encounter in the actual exams. The more you practice, the better understanding you will have on the type of questions you will face. Microsoft has included different types of questions like ‘hot area’, ‘build list and reorder’, ‘drag and drop’, and the latest ’simulation questions’ in its exams.

5. Quiz: The exam quiz helps you learn the technical terms, concepts and definitions, etc., that are essential for the real exams. You can set your own time for the quiz, and can even set the time allowed for each question to appear. Customized pop quizzes can also be created by selecting the topics and number of questions from each topic, so that you can prepare for the real exam quickly and effectively.

6. Track your progress: You should keep track of your progress over time by going through the detailed test report provided at the end of each practice test.

7. Register for the test: Nothing beats than setting a deadline. Therefore, you should register for the test at least two weeks in advance. This helps in building the tempo and keeps you more focused and determined.

8. Quickly review just before taking the test: As your exam day nears, it is a good time to go through a quick review on all the tips, notes, exam alerts and summary given at the end of each chapter. Glance through the topic briefly if you have doubts. Be relaxed and have a good amount of sleep.

P.S.

Maybe many candidates have those questions like would some types of questions on MS be on the exams??

I think if it’s covered in your study materials (i.e. MS Press book), then it’s probably on the exam. Note that MS doesn’t release the number or exact types of questions on the exams. If you use a MS Press book, then it comes with the MeasureUp practice exams. Those are the types of questions you’ll see on the actual exam. No matter what types of questions in your paper, you will succeed in 70-536 as long as you know all subjects fully! How much of the knowledge you grasp is the key in your exams.

Finally ,wish you  successful in your exams !!!

Categories: MCTS Tags:

Thoughts from kabir

August 18th, 2009 admin No comments

Bhala hu meri matki phooti
Main to paniya bharan se chooti

Im glad that my pot broke
Now i don’t have to fil it

Bura jo dekhan main chala
Bura na milya koi
Jo dil khoja apna
to mujhsa bura na koi

Categories: Uncategorized Tags:

ye kyaa ke sab se bayaa.N dil kii haalate.n karanii

March 30th, 2009 admin Comments off

<object width=”425″ height=”344″><param name=”movie” value=”http://www.youtube.com/v/b4NAmUpy2X4&hl=en&fs=1&”></param><param name=”allowFullScreen” value=”true”></param><param name=”allowscriptaccess” value=”always”></param><embed src=”http://www.youtube.com/v/b4NAmUpy2X4&hl=en&fs=1&” type=”application/x-shockwave-flash” allowscriptaccess=”always” allowfullscreen=”true” width=”425″ height=”344″></embed></object>

ye kyaa ke sab se bayaa.N dil kii haalate.n karanii

ye kyaa ke sab se bayaa.N dil kii haalate.n karanii
‘Faraz’ tujh ko na aa_ii.n muhabbate.n karanii

ye qurb kyaa hai ke tuu saamane hai aur hame.n
shumaar abhii se judaa_ii kii sa’ate.n karanii

ko_ii Khudaa ho ke patthar jise bhii ham chaahe.n
tamaam umr usii kii ibaadate.n karanii

sab apane apanee qariine se muntazir us ke
kisii ko shukr kisii ko shikaayate.n karanii

ham apane dil se hai.n majabuur aur logon ko
zaraa sii baat pe barpaa qayaamate.n karanii

mile.n jab un se to mubaham sii guftaguu karanaa
phir apane aap se sau-sau vazaahate.n karanii

ye log kaise magar dushmanii nibhaate.n hai.n
hamii.n ko raas na aa_ii.n muhabbate.n karanii

kabhii ‘Faraz’ naye mausamo.n me.n ro denaa
kabhii talaash puraanii raqaabate.n karanii

Categories: Uncategorized Tags:

That is Called Mind Set

March 26th, 2009 admin 1 comment

 

As my friend was passing the elephants, he suddenly stopped, confused by the fact that these huge creatures were being held by only a small rope tied to their front leg. No chains, no cages. It was obvious that the elephants could, at anytime, break away from the ropes they were tied to but for some reason, they did not. My friend saw a trainer nearby and asked why these beautiful, magnificent animals just stood there and made no attempt to get away.

 

 

“Well,” he said, “when they are very young and much smaller we use the same size rope to tie them and, at that age, it’s enough to hold them. As they grow up, they are conditioned to believe they cannot break away. They believe the rope can still hold them, so they never try to break free.” My friend was amazed. These animals could at any time break free from their bonds but because they believed they couldn’t, they were stuck right where they were.

 

Like the elephants, how many of us go through life hanging onto a belief that we cannot do something, simply because we failed at it once before? So make an attempt to grow further…. Why shouldn’t we try it again?

 

“YOUR ATTEMPT MAY FAIL, BUT NEVER FAIL TO MAKE AN ATTEMPT.”

Categories: Uncategorized Tags:

How to get month date view between two dates in c#

March 24th, 2009 admin No comments

I required month and year view in drop down list between contract starting and ending date. Like “March 2009” “April 2009” until march 2011 so on.

I handled it as follow

DateTime _LoopDate = “1/1/2009”;
string month = string.Empty;
DateTime _EndDate = “1/1/2011”;

while (_LoopDate <= _EndDate)
{
System.Globalization.DateTimeFormatInfo d = new System.Globalization.DateTimeFormatInfo();
month = d.MonthNames[_LoopDate.Month - 1];

drpDate.Items.Add(new ListItem(month + ” ” + _LoopDate.Year.ToString(), _LoopDate.Month.ToString() + ” ” + _LoopDate.Year.ToString()));
//drpdate is dropdownlist
_LoopDate= _LoopDate.AddMonths(1);
}

Categories: Asp.net, c# Tags:

How to get Month name from current date using c#

March 18th, 2009 admin No comments

Hi i found two methods to do so. 

Using Globliziation 

System.Globalization.DateTimeFormatInfo d = new System.Globalization.DateTimeFormatInfo();
 string month = d.MonthNames[DateTime.Now.Month-1];
 

Using new date object as follow

string MonthName = GetMonthName(DateTime.Now.Month);
static string GetMonthName(int monthNum)
{
return GetMonthName(monthNum, false);
}
static string GetMonthName(int monthNum, bool abbreviate)
{
if (monthNum < 1 || monthNum > 12)
throw new ArgumentOutOfRangeException(”monthNum”);
DateTime date = new DateTime(1, monthNum, 1);
if (abbreviate)
return date.ToString(”MMM”);
else
return date.ToString(”MMMM”);
}

Chears

Categories: Asp.net, c# Tags: