Global Package Variable

[aparna_ora]

1) There are records in table. Table has a primary key.
Suppose I disable the Primary key. Add some data. then again enable the primary key. What oracle server checks? Only duplicate records or something else also.

2) What is globle package variable?

[susarlasireesha]

1.Before enable primary key constriant u must Remove the duplicate values or null values in primary key columns .Other wise u will get ORA-02437 error.

2.Variables that you want to remain available between procedure calls in the same session. You can treat variables in a package like global variables