Home »
» Having prob installing Oracle 10g in windows XP 32-bit
5:45 PM
Related Posts:
Colling form condition add.
DECLARE
cl_frm varchar2(10);
begin
cl_frm := GET_APPLICATION_PROPERTY(calling_form);
if
cl_frm='ORF_M03' THEN
SET_TAB_PAGE_PROPERTY('OR_ADVICE', enabled, property_false);
SET_TAB_PAGE_PROPERTY('OR_ADVICE', vis… Read More
Database security issue.
First of all crate this pakage in sys
CREATE
OR REPLACE
PACKAGE SYS.enc_dec
AS
FUNCTION encrypt (p_plainText VARCHAR2) RETURN RAW DETERMINISTIC;
FUNCTION decrypt (p_encryptedText RAW) R… Read More
oracle forms where condition default where
PROCEDURE PRC_SEARCH IS
V_WHERE varchar2(4000);
BEGIN
V_WHERE := 'COMPANY_NO=:GLOBAL.G_COMPANY_NO';
IF :CTRL_SEARCH.SLOT_GROUP IS NOT NULL THEN
V_WHERE := V_WHERE||' AND SLOT_GROUP = :CTRL_SEARCH.SLOT_GROU… Read More
Check duplicate item in block item.
When you want to create a lov
with use where condition
Just use property plate of lov.
Use trigger against:
Lov with item;
Trigger name :
when-mouse-doubleclick with item Level trigger;
Syntax: if show_lov(‘lov_name’)
… Read More
Exception handle
If used function
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN null;
end;
Others
EXCEPTION
WHEN NO_DATA_FOUND THEN
null;
end;
… Read More
0 comments:
Post a Comment