i am displaying image in my region i want to move to the left how can do it means on top of column yymm
Discy Latest Questions
I have a report in my apex app in which in report i have kept page items as parameters through which report gets displayed In which there are page items 1) id 2) image i'm trying to display image based on page item id , my image column gets image through "blob column return by sql statement" i'm not getting Image based on id i tried all dynamic action like refresh page item image when id is changed can any one help me out?
Hi Sir, I have a question about a function that I call in a before-header process to redirect to the appropriate page. create or replace function redirect_page(p_user_name in varchar2) return varchar2 as v_redirect_url varchar2(100); branch_page table_1.PAGE%type; v_state table_1.STATE%type; v_finalpaper_id table_1.fpid%type; begin begin select fp.state, fp.page,fp.id into v_state, branch_page,v_id from table_1 fp left outer join users u on u.uuid=fp.uuid where lower(u.username)=lower(p_user_name); if v_state ='REQUESTED'then v_redirect_url:='f?p=100:95:&APP_SESSION.::NO::P95_ID:'||v_id; elsif v_state ='APPROVED'then v_redirect_url:='f?p=100:92:&APP_SESSION.::NO::P92_ID:'||v_id; end if; exception when no_data_found then v_redirect_url:='f?p=100:1:&APP_SESSION.::NO::'; end; return v_redirect_url; end; Now, when I call the function in the page, I get the 500 Internal Server Error DECLARE v_redirect_url VARCHAR2(100); BEGIN v_redirect_url:=redirect_page_finalpapers(:session_user_name); htp.init(); owa_util.redirect_url(v_redirect_url); apex_application.g_unrecoverable_error := true; END; I don't quite understand why this happening and would appreciate some help on here?
I have a form in my Oracle Forms application for Developing form i'm using Oracle Form Builder 10G,Now user has to write login id and password(authentication) to use the form i want to keep a button in the form so when user presses the button he is directly moved to oracle apex application without Writing login id and password(authentication) What i want to do is Once user does authecation in oracle forms application he doesnot have to authticate again in oracle apex
create or replace FUNCTION base64encode(p_blob IN BLOB) RETURN CLOB IS l_clob CLOB; l_step PLS_INTEGER := 12000; -- make sure you set a multiple of 3 not higher than 24573 BEGIN FOR i IN 0 .. TRUNC((DBMS_LOB.getlength(p_blob) - 1 )/l_step) LOOP l_clob := l_clob || UTL_RAW.cast_to_varchar2(UTL_ENCODE.base64_encode(DBMS_LOB.substr(p_blob, l_step, i * l_step + 1))); END LOOP; RETURN l_clob; END; Please Explain this Function.