Hi Jeff, Thanks for the video. I am trying to implement one after insert trigger on a table. Whenever there is a new insert action happens on that table, trigger should get enabled and it should hit one API without expecting any response. Can you please guide me how to implement this... Thanks in advance🙏
@@JeffSmiththat No, I just want to hit the API URL through table specific trigger. Basically that trigger will be of type "after insert". So whenever user inserts data into that particular table, trigger should get enabled and should hit that api URL. Create trigger Mytrigger After Insert On Test_table For each row Declare Api_url varchar2(100) := 'testing.test.com:5550/checkrow'; Body_url varchar2(100) := 'row inserted'; Begin // Need to know what to write here to hit above mentioned URL with that body and without expecting any response End;
@@Anonymousvlogger1 what does your URL do? The db can make api calls with the HTP.P() interface or you can use a handy package from APEX if that's installed, APEX_WEB_SERVICE oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services
That's a broad question...one example would be calling a stored procedure which makes a change to your data. It could return a status and message or perhaps a link to an added resource. Example here www.thatjeffsmith.com/archive/2018/11/building-a-web-service-for-uploading-and-downloading-files-the-video/
Tomcat and WebLogic have this out of the box. If you're running ORDS standalone you would need a URL you could hit for a heartbeat...and you'd check the ords process itself obviously. You can also enable access logs for the Jetty webserver
@@JeffSmiththat hi Jeff , thank you for your quick reply am using tomcat not a standalone I have to do monitoring we can use any other technologies you have any idea please suggest me
@@anusuyaperumal2155 there's a wide range of free and $ monitoring solutions for Tomcat, plus tomcat docs shows how to do this via tomcat.apache.org/tomcat-7.0-doc/monitoring.html
Hey Jeff, I tried to create the hello world (message) module (at 9:59) in an existing schema (non-ORDS related) and I got the following error when the SQL code to run packages ORDS.DEFINE_MODULE, ORDS.SET_MODULE_ORIGINS_ALLOWED and ORDS.DEFINE_TEMPLATE: Failed to process SQL command - ORA-01403: no data found ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 617 ORA-06512: at "ORDS_METADATA.ORDS_SECURITY", line 63 ORA-06512: at "ORDS_METADATA.ORDS", line 722 ORA-06512: at line 2 I'm running ORDS in stand alone mode (install looks good). Furthermore I can see ORDS_METADATA and ORDS_PUBLIC_USER schemas. Did I need to grant ORDS related roles to my schema?
Hi Jeff, Can you please share similar example where REST service is calling a package.procedure with IN and OUT parameters and we can pass IN parameters to get the result.?
Hi Jeff, are there any tutorials to install ORDS and APEX? I am specially interested in deploying ORDS on a standalone server using Apache Tomcat and have that talk to an APEX install on my 12c database where I am running EBS 12.2.4. Thanks! Julio
You can do a simple install, Java -jar ords.war and follow the prompts. Then you can drop that war file right into your Tomcat server. You'll need SYSDBA access if you want to setup ORDS rest on your DB.
As I understand it, you let your web server/Tomcat handle that, and ORDS just settles into that ecosystem stackoverflow.com/questions/27362588/mutual-authentication-with-tomcat-7
Hi Jeff, I am trying to configure REST service for table present in sys schema. Basically want to configure for oracle data audit table sys.aud$ table. Can we do it for sys schema table? Thanks, Prachi
The AUTO feature isn't designed for SYS. What you want to do is build a RESTful Service, so write a GET Handler in another schema with SELECT privs on SYS.AUD$ to get access to your auditing data for example.