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.
Dear Sir, I am using oracle database 11gr2 to connect to gmail and read messages. but I facing this error while connecting to gmail. ORA-29532: Java call terminated by uncaught Java exception: javax.mail.MessagingException: Connect failed; nested exception is: java.io.IOException: Couldn't connect using "javax.net.ssl.SSLSocketFactory" socket factory to host, port: imap.gmail.com, -1; Exception: java.lang.reflect.InvocationTargetException ORA-06512: at "IMAGE.MAIL_CLIENT", line 16 ORA-06512: at "IMAGE.MAIL_CLIENT", line 35 ORA-06512: at line 2
Hello, I am using Oracle APEX 20.2 and am looking for a way to use an existing interactive report to generate a BLOB .csv file and insert it into a database table. I need to do this so I can query the file for an email attachment through send_mail, so there may be a better way to perform the action where data from an interactive report populates a .csv file and attaches it to an email and sends it. How would I do this?
I want to select records on IG on page load through apex.region("S_KRAFTSTOFFE").call("setSelectedRecords",[$v('P17_BEZ_ID')]) wherein the 'P17_BEZ_ID' has value "'Super Plus 98','Super 95','Diesel','Super E10','Ad blue (Gebinde)','Autogas (LPG)'" My problem is because P17_BEZ_ID is a string i cannot directly assign to setSelected records Please see the attachment in short i want to assign a string "'Super Plus 98','Super 95','Diesel','Super E10','Ad blue (Gebinde)','Autogas (LPG)'" to an IG with each element of string as one row of the IG
Hello Sir, How can I preserve the checkbox in an Interactive Report with Select All option (eg, Report on EMP table). Once selected then need to load the selected rows into a new table (EMP_NEW). Your help and support would be appreciated.
Hi everyone, I created custom user access control , in this i want to restrict each user to one session, that is once the user login if he doesn’t logout he can not login once again, One user can have a single session How do i do this? Any help would be highly appreciated…