You’re using ORDS. You’ve written some web services. Now you need to control the underlying PL/SQL source. How do I get the code out? There’s a few ways. 1. Use SQL Developer On the Module, mouse right click. 2. Use SQLcl The REST command will get what you want. If you want this in a file, just use the SPOOL command. 3. Get it Yourself with SQL The ORDS_METADATA schema comes with some PL/SQL packages…

Today’s question: Does ORDS support PUT/POST with Array or Cursor as part of the payload? I need to call a procedure with 1 IN parameter defined as Array or Cursor (for a list of IDs). The answer is Yes, and I’ll show with the AUTO Feature. The Underlying Code: 6180094055d59061cba335_000001 Executing FORUMS_PLSQL_TABLE.INS_C() via POST First, let’s Auto PL/SQL Enable the Package. 6180094055d59061cba335_000002 Second, let’s call the package. 6180094055d59061cba335_000003 So in my POST I passed a…

Slideshare won’t let you update slide decks anymore, so I just uploaded my latest version as a new offering. All of the Performance Tuning Features in Oracle SQL Developer, 2018 Edition from Jeff Smith I’ll be presenting this topic at UKOUG this week. if you’d like me to present this to your group of the developers and administrators, drop me a note, and we’ll setup a webinar. A Custom Design Rule – Do I Have…

This post won’t show you how to acutally do the scheduling bits – I’m going to assume you know how to use contrab or Windows Scheduler -but I will show you how to get SQL Developer setup so that you can call it from the command-line to do your export. Our requirements – from an AskTom question – I want delimited text output, TABs the numbers need to be quoted I’m running on Windows BUT…

Here’s an 8 minute video walk through of using INFO and DESC in Oracle SQLcl. You can decide what works better for you – hey, maybe you’ll decide to use both! INFO shows more info INFO+ shows more info with more stats You can INFO a package OR a package.procedure Enjoy! PS – I made this on my new rig Mac Mini, 4k screen, but I filmed for 1080p resolution. I’m also using a new…

The 2018 conference season is winding down. Next week is DOAG in Germany – an amazing conference by the way – and a short time after that is the UKOUG Tech 2018 conference in Liverpool, England. This will be my second experience presenting at UKOUG, and I’m looking forward to reconnecting with old friends and meeting new folks – all while talking about ORDS and SQL Developer. The Tuning in SQL Developer talk is a…

So someone asked us on Twitter this morning about a new Document that opens on an Export of a query result set. How can I prevent the "Export Tool" log in SQL Developer 18.3?I get it whenever I create some DDL over the navigation [email protected] @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6— Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that wasn’t intentional – it’s a BUG. Good news – we HAVE cleaned that up for version…

This video is a bit longer than most, but I’ll show you how to deploy a web service to: get a list of files from a table – stored as BLOBs get individual file details download/render the file using the mime type how to upload a file how to generate LINKs in your {json} responses how to set the HTTP Status Codes for your responses The Video Skip the Intro, Go Straight to the Demo.…

One of the improvements for version 18.3 was a much improved, performant query builder. Of course, not all things are free. Or in fact, nothing is free. So who paid for these performance gains? We disabled one of its primary features. But first, let’s take a step a back and explain the scenario. How it Was, Pre 18.3 The query builder would allow you to reverse engineer a query in a worksheet to a visual…

This was one of my 3 sessions at Open World last week. None of them were recorded, but I figured you might find this one interesting, so I ran through the slides again here. If you search this blog for things like ‘18.1’, ‘18.2’, and ‘18.3’, you can find all the blog posts I put together showing some of these features. But a short list would definitely include: SQL Injection Detection Faster Query Builder &…

In my Oracle REST Services Demos I always show things working exactly as planned. But what happens when your user does something your program doesn’t expect? Or what happens when you code does something you don’t expect? In the web (HTTP) world, you get a 500. 10.5.1 500 Internal Server Error The server encountered an unexpected condition which prevented it from fulfilling the request. Thankfully, PL/SQL provides EXCEPTIONS. We can say, when this bad thing…