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
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?
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.
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
I am trying to escape & from the prepare_url function, I use URL as a public bookmark. For insatnce: APEX_UTIL.PREPARE_URL ( p_url => 'f?p=' || :APP_ID || ':1:'|| :APP_SESSION ||'::NO::P1_ID:'|| x.ID ||'', p_checksum_type => 'PUBLIC_BOOKMARK', p_url_charset => 'UTF-8')
Hi, My workflow is: Press button "SAVE" Validation If pass then a submit processing A question "Do you want to send a mail?" If OK - to send mail. My problem is that Confirm Message is javascript. Where's a point of that in submit processing? Thanks
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.
1 error has occurred Unable to enable schema for ORDS RESTful services. ORA-20018: Schema or user name must be a simple uppercase unquoted literal
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…