Use table with DBLINK and without DBLINK I have a procedure to use with DBLINK but I also need to use it without DBLINK, I could duplicate the procedure and it is already solved. But I want to just have an Oracle pl/sql procedure that can be used with DBLINK and that can also be used without DBLINK Please can you help me. CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER) AS BEGIN UPDATE accounts@dblink_histo SET balance = new_balance WHERE acct_id = acct; COMMIT; END credit_account; I do not want to repeat the following procedure that does not have DBLINK CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER) AS BEGIN UPDATE accounts SET balance = new_balance WHERE acct_id = acct; COMMIT; END credit_account; How can I use the table with DBLINK and without DBLINK so as not to repeat another procedure? Do you help me please?
Discy Latest Questions
Hello, my boss asked me to carry out a task, but I have doubts, he asked me to create an application where I could edit the Excel table that was uploaded within the apex itself, and then be able to compare the previous table with a new one that was added later
I want to display image in BI Publisher report in MS Word. I am downloding query xml file from Oracle Apex. Like :- SELECT name, image FROM Image_table. When I upload sample xml in BI publisher it don't show any data. Any Idea how do it ??
Hi. How can I include DATE RANGEĀ search criteria in Faceted Search? (while I was trying, I am getting the following error. Facet is not supported for DATE or TIMESTAMP columns.) Thanks,
Can apex_mail.send be called from outside of apex 20?
Hi! I have page with ajax callback which is executed on button click (submit). After I move page to modal dialog, ajax callback doesn't work. How to use ajax callback in modal dialog page?
How to save and remember user login page in Apex 20?
Hi sir ji,How to show confirmation message for logout/signout when the user clicks the signout button from navigation bar list and redirect to logout url. can u please suggest.
when i press button for print then report should beĀ send to directly on printer instead any popup/page . How can we achieve this using BI Publisher or Jasper Report . please share code whose attempted this one task. Thank You.
I have a form to load data and there are several items, I put them one below the other and they take up a lot of vertical space, even more when working on a mobile device how to modify distance between lines in an apex 20 form ?