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 ?
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
hi guys any one implemented / integrated Weight Scale machine or Attendance machine with oracle developer 12c / 11g. ?
syntax is ok but showing error "ORA-20001: Query must begin with SELECT or WITH error"
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…