|
| 07:57:58 | * Chaitanya Koratamaddi | Morning/Evening all! This session will be recorded. So, please turn off your Video. Thanks. |
| 07:59:50 | Ian Raum | I'll sign up for that class |
| 08:10:57 | Sven Weller (syntegris) | Are all the workspaces/schemas on apex.oracle.com rest enabled? |
| 08:11:17 | * Joel Kallman | Not automatically, but you could enable them. |
| 08:13:54 | Scott Wesley | I've always found this part the most confusing |
| 08:14:53 | Scott Wesley | (URL breakdown, for the record) |
| 08:21:43 | Sven Weller (syntegris) | For the record: trying to migrate the APEX rest service "oracle.example.hr" gave an error (because it exists already): Unable to migrate services. unique constraint (ORDS_METADATA.ORDS_MODULES_UNIQUE1) violated |
| 08:22:07 | Daxlai | how i install ORDS where apex not installed on db |
| 08:22:23 | Sven Weller (syntegris) | Would be nice if the migration wizard has an option to ignore services that do exist. |
| 08:23:50 | EJ Egyed | AutoREST enabling a view does create POST, PUT and DELETE endpoints |
| 08:24:11 | Sven Weller (syntegris) | @Daxlai it is a separate download and installation. https://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html |
| 08:24:22 | Ashok | i have two blob parameter... like one is Image in BLOB and second is xml payload in CLOB. How do we pass both in single rest service, if i am creating rest service from apex scrern |
| 08:24:53 | * David Peake | @Daxlai - Simply follow the ORDS Installation Guide to install ORDS into Oracle WebLogic Server, Apache Tomcat, or standalone using the (built-in) Jetty server … Once installed you can then define ORDS to work with one or more Databases |
| 08:28:43 | Sven Weller (syntegris) | Would PATCH instead of PUT work differently? Or is there no PATCH for AutoREST? |
| 08:30:28 | * David Peake | @Sven - There is no PATCH Handler |
| 08:30:55 | Sven Weller (syntegris) | Ok. |
| 08:33:30 | Ashok | service created using ORDS IN SQL developers visible in apex? |
| 08:34:07 | * David Peake | @Ashok - Yes they are in the ORDS REST Workshop (not in the legacy APEX REST Workshop) |
| 08:36:20 | Ian Raum | I've got this in another example with the optional paramter in {id} instead of :id? |
| 08:37:31 | * David Peake | @Ian - I will ask Doug during the Q&A if there is any difference between the two |
| 08:38:34 | Amer | can i use location as parameter to return empno using RETURNING Keyword. I had error ,when i used it |
| 08:38:46 | Kevin Zhang | where is the "COMMIT" in the code? Is client need to commit? |
| 08:39:15 | EJ Egyed | Wasn't X-APEX-STATUS-CODE deprecated for X-ORDS-STATUS-CODE? |
| 08:39:21 | Sven Weller (syntegris) | So for each bind variable that we have in the source and where no parameter definition exists -> ORDS will create a json object {key:value} - did I understand this correctly |
| 08:40:03 | EJ Egyed | X-APEX-STATUS-CODE was deprecated in ORDS 18.3 https://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/ords-relnotes-183-5100543.html |
| 08:40:53 | Vivek Ananda | what if I want to null a column value . |
| 08:40:55 | Eric Olson | Just pointing out that NVL pattern means you cant set a column to null. |
| 08:41:41 | Kevin Zhang | question again: I don't see "COMMIT" in the code for DELETE/PUT/POST etc ... so who is control the final commit? |
| 08:41:55 | * David Peake | @Kevin - I will ask Doug during Q&A |
| 08:42:18 | Scott Wesley | I would have thought it's implicit, just like all the other transactions in APEX land. |
| 08:44:51 | Kevin Zhang | Will Oracle APEX support GraphQL in future? |
| 08:45:05 | Olivia Ding | What is the tool Doug using |
| 08:45:18 | * David Peake | @Olivia - Postman |
| 08:45:18 | Kyle Hu | “Postman” |
| 08:45:19 | Ashok | :body and :body_clob both parameters available in ords 18.3 onwards |
| 08:46:17 | Mike M | Postman |
| 08:46:34 | Olivia Ding | Thanks |
| 08:51:32 | Sven Weller (syntegris) | What is the goal of this APIs(Beta) tab in the upper left corner ? |
| 08:52:43 | * David Peake | @Sven - I assume you saw that in Postman … I’m not sure what that is for |
| 08:53:12 | Sven Weller (syntegris) | Yes, here on postman |
| 08:53:31 | Sven Weller (syntegris) | ok, nevermind, probably some postman stuff |
| 08:55:28 | Eric Olson | Did you say you have to create an OAuth client for each *user*? |
| 08:56:42 | Sven Weller (syntegris) | @Eric: I assume this would be part of an application (could be an apex application) that consumes this webservice. |
| 09:07:46 | Amer | What ist the difference (Performance) between apex_web_service.make_rest_request and apex_exec.execute_web_source |
| 09:08:18 | Amer | when i want to revoke webservice |
| 09:09:09 | mentzel iudith | Excellent session, thanks a lot :) |
| 09:09:10 | Romina Jalon | Thanks! |
| 09:09:13 | Kevin Zhang | excellent session!!! |
| 09:09:25 | Kenny | thanks guys |
| 09:09:25 | Amer | Thanks |
| 09:09:28 | Anton G | ta |
| 09:09:28 | LarameeG | Excellent session Thanks |
| 09:09:29 | Angel Rosario - 3Core Solutions | thanks |