|
| 07:52:33 | Daxlai | i want to know how to know how to debug in apex, i am just migrate from oracle forms & report |
| 07:53:37 | JESUS MORENO (TECNICA24) | Very easy: in developer bar, just click in "debug" and then "session" to have a look to session state values |
| 07:55:21 | Daxlai | is there any step in and step out? like in forms line by line debug |
| 07:56:28 | * Chaitanya Koratamaddi | Good Morning! |
| 07:56:38 | * David Peake | @Daxlai - You can step into PL/SQL code by enabling Remote Debugging with SQL Developer |
| 07:57:01 | JESUS MORENO (TECNICA24) | No, apex apps render pages to your browser in one step, you can not stopping/starting regions inside pages like you would do in a desktop app |
| 07:57:04 | Juan Lopez | Hello everyone!! Regards from Malaga, Spain! |
| 07:57:52 | JESUS MORENO (TECNICA24) | Un poco de español: saludos Juan! |
| 07:58:45 | Eric | Good morning all! |
| 07:58:48 | Brian | great sessions, I'm new to apex but really am impressed with the power of it. lots to learn |
| 07:58:54 | Eric | (or afternoon or evening!) |
| 07:59:04 | Aravindan | Gud Evening |
| 07:59:11 | Olivia Ding | Good evening from China |
| 07:59:20 | Mahendra Sonawane | Good Evening |
| 07:59:23 | Juan Lopez | Hola Jesus! ;) Un placer saludarte! |
| 07:59:47 | * David Peake | @Brian - Go to https://apex.oracle.com/hols for some great beginner labs |
| 08:00:23 | Brian | thanks |
| 08:02:01 | * David Peake | Can everyone please turn off their video |
| 08:03:33 | Richard | Good evening from India |
| 08:03:44 | Steven Feuerstein | Glad you could join us, Richard! |
| 08:05:18 | Kevin Zhang | Good morning from Chicagoland ... |
| 08:08:26 | * David Peake | Please enter your questions in the chat <here> and I will try to ask Carsten during the Q & A section of this session |
| 08:09:13 | Juan Lopez | Great effort, David. Thanks a lot! ;-) |
| 08:11:34 | Kevin Zhang | Is there any permission we need to open in database (APEX installed in it) to allow consume REST web services from a provider (e.g. twitter) |
| 08:12:01 | Ricardo Francisco | hi everyone... we have brazilians here! |
| 08:14:00 | Venkat | You must have 30inch monitor but for us the screen is so small |
| 08:14:01 | Olivia Ding | the window is too small |
| 08:14:04 | * David Peake | @Kevin - Yes you need to set the Proxy Server as Carsten just showed |
| 08:14:49 | Juan Wall | thanks! |
| 08:14:55 | * David Peake | @Olivia - Hope that is better |
| 08:14:56 | Venkat | Thanks!! |
| 08:15:12 | Olivia Ding | Thanks~ |
| 08:18:56 | Kevin Zhang | Is there any tool inside APEX to test if REST web service I have configured is correct/working? something like Postman does ... |
| 08:19:22 | Hany | from where we can test web source after creating ? |
| 08:19:27 | Eric | Star trek is hard coded, how do you take it as a parameter from the user? |
| 08:21:50 | * David Peake | @Eric … Carsten should cover shortly |
| 08:22:07 | Eric | thx. thought he would! |
| 08:22:23 | Kevin Zhang | Can you Carsten change the api_key value to an invalid value and I want to see what is the result if api_key is invalid ... I want to see the error handling of APEX in such case ... thanks! |
| 08:24:03 | * David Peake | @Kevin - I will ask Carsten to do so during the Q & A section |
| 08:24:55 | Ross Henderson | Is there functionality in APEX to create API wrappers? |
| 08:25:16 | MBTRIPAT | How Apex Rest handles, if the volume of data is large? |
| 08:25:17 | Ghyslain Laramée | Good morning from Gatineau, Québec, Canada |
| 08:25:51 | * David Peake | @Ross - Yes, under SQL Workshop > REST Services you can define REST endpoints on schema tables |
| 08:26:19 | Eric | Without google, what would we do! ;) |
| 08:26:29 | Ross Henderson | Thanks David |
| 08:26:35 | Kevin Zhang | Is there any tracing/log information out of box to tell me information such as: # of times a web service has been invoked ... the status of each invoking (good vs fail) ... Basically, I am looking for a page where I can monitor the web service within my application ... It will make support/troubleshooting easier ... |
| 08:27:30 | * David Peake | @Kevin — gr8 qu … can you please repost when we get to Q & A |
| 08:27:58 | Kevin Zhang | sure ... I will repost my questions when Q&A is open ... |
| 08:28:26 | * David Peake | … One way to make sure Kevin stays on until the end ;) |
| 08:29:35 | Pete K | I had a go with web source modules at a developer event recently and it only took half an hour to go from no knowledge of them to having a working interactive report of the data. They really save a lot of time. Unfortunately I'm still suck with Apex 5.1 at work for now! |
| 08:30:43 | * David Peake | @Pete - Gr8 justification to upgrade so you can consume REST so easily |
| 08:34:23 | Daxlai | from where we get 18.2 |
| 08:34:38 | * John Snyders | the future |
| 08:34:46 | * David Peake | @Daxlai APEX 18.2 is not released yet |
| 08:35:17 | Eric | Where is Doc Brown when you need him? ;) |
| 08:35:20 | wydot | can we cover what are the best practices for securing Rest enable SQL |
| 08:37:20 | * David Peake | @wydot - Carsten just showed how you have to enter authentication for theSQL to work |
| 08:38:07 | saursinh | . |
| 08:39:40 | Ross Henderson | Can you use Oracle REST Enable SQL to interact with other Oracle products, such as JDE? |
| 08:39:57 | Richard | can you please provide some input on using REST to connect to SAAS application? (any module) |
| 08:40:21 | Eric | Can the authentication be parameterized after authentication by apex? |
| 08:40:43 | * David Peake | @Ross - Yes if JDE on Oracle DB (It can also be installed on other DBs) |
| 08:41:26 | Ross Henderson | @David Awesome, thanks for that. |
| 08:43:07 | Juan Wall | Can Web Modules created in ORDS (out of the APEX internal schema) be visible in APEX Web Source Modules? |
| 08:45:31 | Tracy | Can it integrate with SSO? |
| 08:45:35 | Eric | What I meant was the authentication supplied to Oracle Rest being driven from the user authenticated by oracle apex |
| 08:45:46 | Richard | some input on using REST to connect to SAAS please.... |
| 08:46:03 | * David Peake | @Richard - I will ask Carsten |
| 08:46:22 | Richard | Thanks David |
| 08:46:27 | * David Peake | @Eric - This is connecting to the DB not as a user but as a DB user |
| 08:48:39 | Eric Olson | Does Apex automatically URL-escape a page item parameter when it puts it in the URL call to a web service? |
| 08:48:42 | Eric | But can the user that you connect to the DB be driven by the username that was authenticated by Apex? Maybe this is an SSO question that Tracy referes to. |
| 08:49:07 | Kevin Zhang | Kevin(Chicago) - Q4: in APEX 18.x, will Oracle REST web service only works for https, not http? What is my APEX ORDS is http and remote web service provide is https, will this work? |
| 08:49:07 | Kevin Zhang | Kevin(Chicago) - Q2: Can you change the api_key value to an invalid value and I want to see what is the result if api_key is invalid ... I want to see the error handling of APEX in such case ... thanks! |
| 08:49:07 | Kevin Zhang | Kevin(Chicago) - Q1: Is there any tracing/log information out of box to tell me information such as: # of times a web service has been invoked within APEX ... the status of each invoking (success vs fail) ... Basically, I am looking for a page where I can monitor the web service within my application ... It will make support/troubleshooting easier ... |
| 08:49:07 | Kevin Zhang | Kevin(Chicago) - Q3: Will APEX plan to support GraphGL technology which is a query language for API (https://graphql.org/). It has some siginificant performance gain comparing to REST web service. If future APEX can support GraphGL and REST web service, that will be super |
| 08:49:09 | Kevin Zhang | Kevin(Chicago) - Q5: for REST enabled SQL demo, if you shut down remote database, what your APEX will react? Again, I want to see how error handling is be done in APEX if remote db is down or not avaialable. Hope APEX can display a nice meaningful message in such case. |
| 08:49:09 | Kevin Zhang | Kevin(Chicago) - Q6: Can we download this demo application from somewhere? |
| 08:50:31 | * Hilary Farrell | @Kevin - Shakeeb tweeted about the Movies app a couple of weeks ago - https://twitter.com/shakeeb/status/1011275880855953408 |
| 08:51:21 | Kevin Zhang | Kevin(Chicago) - Q 7: will this demo work for Oracle DBMS 11GR2, or it requires Oracle DB 12c/18c? |
| 08:52:55 | Ross Henderson | Hah, we just built an HTTP Management app to do exactly that |
| 08:57:05 | * Hilary Farrell | @Kevin - to see the error handling you've asked about, given the remaining time, it's probably best if you try out the Movies app for yourself - obtaining your own api key, and try things out on your instance |
| 08:57:51 | Juan Lopez | Thanks a lot guys. It's been a great session! I'll catch up with the rest of questions when recorded session will be available!! Thanks again and have a great day!! ;-) |
| 08:58:04 | * Doug Gault | WRT Sending/Receving LARGE amounts of JSON data. I'm working on a system that sends 380MB of data in one JSON Packet. I'm Base64 Encoding then compressing it to send it to the service (which expects the compressed packet). |
| 08:59:35 | Jerry (Gerald) Sidler | Thanks apex Team another awesome presentation |
| 09:00:03 | Kevin Zhang | Will APEX plan to support GraphGL technology which is a query language for API (https://graphql.org/). It has some siginificant performance gain comparing to REST web service. If future APEX can support GraphGL and REST web service, that will be super |
| 09:00:24 | * Hilary Farrell | @Kevin - no plans as yet |
| 09:00:48 | Ross Henderson | Last question, hate to ask it - Any update on the AWS uptake of 18.1? |
| 09:01:12 | * David Peake | @Ross we have reached out to them and they are working on it |
| 09:01:31 | Ross Henderson | @David Thanks for the update. Great session today, I've learnt a huge amount. Thanks guy! |
| 09:02:21 | Richard | @David, you were telling somebody is working on APEX with SAAS, if any document or blogs, please do share...thank you.. |
| 09:02:49 | * David Peake | @Richard search for APEX JMJ Cloud and read their blogs |
| 09:02:54 | Eric | Thanks Carsten/David! So much information! |
| 09:02:58 | Richard | sure, thanks David |
| 09:02:59 | Anca | thank you! |
| 09:02:59 | mentzel iudith | Thanks a lot Carsten, you are definitely the one who should write the APEX documentation books ,to make them more comprehendable for APEX beginners :):) |
| 09:03:06 | Juan Wall | Thanks Carsten, great presentation! |
| 09:03:15 | Richard | Thanks Carsten |
| 09:03:17 | hvarman | Thanks a lot Carsten..great session |