❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
pop lov based on Page Item Values
Abdul Aqeel Malik
Dear vinish, waiting for your comments and guidance.
Dear vinish,
waiting for your comments and guidance.
See lessInsert Image into BLOB manually
Abdul Aqeel Malik
Dear Ashish Sahay , can you please point out where is the problem in codes. Following Javascript to call ajax callback process. apex.server.process("bank_payment_mst", { pageItems: "#P17_DATE,#P17_PROOF1", x01: $v(P17_DATE), x02: $v(P17_PROOF1) }, { success: function (pData) Read more
Dear Ashish Sahay ,
can you please point out where is the problem in codes.
Following Javascript to call ajax callback process.
apex.server.process("bank_payment_mst", {
pageItems: "#P17_DATE,#P17_PROOF1",
x01: $v(P17_DATE),
x02: $v(P17_PROOF1)
},
{
success: function (pData) {
// Codes in Case of Success
apex.item('P17_VNUMBER').setValue(pData.vno);
},
error: function( jqXHR, textStatus, errorThrown ) {
// Codes in Case of Error
}
});
following is ajax callback process.
declare
mid int;
l_proof1 blob;
begin
select nvl(max(mid),0)+1 into mid from voucher_mst;
SELECT blob_content
INTO l_proof1
FROM apex_application_temp_files
WHERE NAME = apex_application.g_x02;
insert into voucher_mst values(mid,apex_application.g_x01,apex_application.g_x02);
apex_json.open_object;
See lessapex_json.write('mid', mid);
apex_json.close_all;
exception when no_data_found then
raise_application_error(-20111,'problem saving ');
end;
following is error in console.
Insert Image into BLOB manually
Abdul Aqeel Malik
Dear Vinish, please guide me about above mention code to complete my form.
Dear Vinish,
please guide me about above mention code to complete my form.
See lessHOW TO FIX COLUMN OF INTERACTIVE GRID
Abdul Aqeel Malik
Freezing column may fix the problem
Freezing column may fix the problem
See lessInsert Image into BLOB manually
Abdul Aqeel Malik
can you please tell me what is wrong in following code. declare mid int; l_blob blob; begin select nvl(max(mid),0)+1 into mid from voucher_mst; SELECT blob_content INTO l_blob FROM apex_application_temp_files WHERE NAME = :P15_PROOF1; insert into voucher_mRead more
can you please tell me what is wrong in following code.
declare
mid int;
l_blob blob;
begin
select nvl(max(mid),0)+1 into mid from voucher_mst;
SELECT blob_content
INTO l_blob
FROM apex_application_temp_files
WHERE NAME = :P15_PROOF1;
insert into voucher_mst values(mid,l_blob );
apex_json.open_object;
apex_json.write('mid', mid);
apex_json.close_all;
exception when no_data_found then
See lessraise_application_error(-20111,'Some thing Went wrong');
end;
Insert Image into BLOB manually
Abdul Aqeel Malik
Dear Vinish, waiting for your early response.
Dear Vinish,
waiting for your early response.
See lessHow to submit the item value and refrer in another item without submitting the page
Abdul Aqeel Malik
you need DA and set value of page item you want to be updated. create dynamic action when you need to update page item. Type should be Set Value. setting => Set type = Java Expression in javascript expression write following accounting to your page item to be copied $v('your_page_item'); AffectedRead more
you need DA and set value of page item you want to be updated.
create dynamic action when you need to update page item. Type should be Set Value.
setting => Set type = Java Expression
in javascript expression write following accounting to your page item to be copied
$v('your_page_item');
Affected Item => Selection Type => Item(s)
Item(s) = select page item
that's all
See lessStop Success Message On Page Refresh
Abdul Aqeel Malik
following code shall remove any success or error message on page. apex.message.clearErrors(); apex.message.hidePageSuccess();
following code shall remove any success or error message on page.
apex.message.clearErrors();
apex.message.hidePageSuccess();
See lessHow to call database procedure on button click
Abdul Aqeel Malik
create dynamic action on button click. Action = Server side code Language = PL/SQL in pl/sql code write as bellow begin your_procedure_name(list of parameters here); end; that's all. if things are ok it shall do the job
create dynamic action on button click.
Action = Server side code
Language = PL/SQL
in pl/sql code write as bellow
begin
your_procedure_name(list of parameters here);
end;
that's all. if things are ok it shall do the job
See lesssaving image in table vs application directory in oracle apex
Abdul Aqeel Malik
thanks. this procedure is to convert blob in table to file. In my case if I get file with file browser and when user press save button I want to change file name to voucher number just saved and save file on disk. I think for this purpose we don't need to save file into blob table and than convert tRead more
thanks. this procedure is to convert blob in table to file.
See lessIn my case if I get file with file browser and when user press save button I want to change file name to voucher number just saved and save file on disk. I think for this purpose we don't need to save file into blob table and than convert to file. please guide me if I am wrong.