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
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?
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.