Page 47 of 95
Package Specification contains declarations that are global to the
packages and local to the schema.
Package Body contains actual procedures and local declaration of
the procedures and cursor declarations.
38. What is difference between a Cursor declared in a procedure and
Cursor declared in a package specification ?
A cursor declared in a package specification is global and can be
accessed by other procedures or procedures in a package.
A cursor declared in a procedure is local to the procedure that can
not be accessed by other procedures.
39. How packaged procedures and functions are called from the
following?
a. Stored procedure or anonymous block
b. an application program such a PRC *C, PRO* COBOL
c. SQL *PLUS
a. PACKAGE NAME.PROCEDURE NAME (parameters);
variable := PACKAGE NAME.FUNCTION NAME (arguments);
EXEC SQL EXECUTE
b.
BEGIN
PACKAGE NAME.PROCEDURE NAME (parameters)
variable := PACKAGE NAME.FUNCTION NAME (arguments);
END;
END EXEC;
c. EXECUTE PACKAGE NAME.PROCEDURE if the procedures does not have
any
out/in-out parameters. A function can not be called.
40. Name the tables where characteristics of Package, procedure
and functions are stored ?
User_objects, User_Source and User_error.
FORMS4.0
12. what is a display item?
Display items are similar to text items but store only fetched or
assigned values. Operators cannot navigate to a display item or edit
the value it contains.
13. What is a list item?
It is a list of text elements.
14. What are the display styles of list items?
Poplist, No text Item displayed in the list item.
Tlist, No element in the list is highlighted.
15. What is a radio Group?
|
|