| Doubt regarding Library and Package [message #87758] |
Mon, 07 February 2005 20:01 |
Kasim
Messages: 22
Registered: August 2004
|
Junior Member |
|
|
Hi ,
I have 2 doubts.
A) Could you please explain me the difference between Library in D2k forms 6i and Packages in Oracle.
Because both are seems to similar in several aspects, importantly,
1. Avoiding network traffic.
2. Can be accessible from all modules in the application.
3. Encapsulation and Overloading concepts. etc.
But I like to know from where it differs. Why we should use Library and why we use Packages?
B) In triggers like 'WHEN-VALIDATE-ITEM' etc, I can code like,
IF :system.record_status IN ('INSERT','CHANGED') THEN
---- SOME STUFFS---
END IF;
It compiles properly without any errors. But while I write the same code in Library (Program Units)it displays error message like, bind variable :system not found... why is it so..
But it compiles when I code like...
IF name_in('system.record_status') IN ('INSERT','CHANGED') THEN
---- SOME STUFFS---
END IF;
Why it requires single quotes in it instead of colon.
Kindly clarify my doubt...
Anticipating your response...
Regards,
Roshini.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
