tag:blogger.com,1999:blog-8449039.comments2023-11-23T02:29:35.504-05:00Scott Spendolini's BlogScotthttp://www.blogger.com/profile/01187435106015051061noreply@blogger.comBlogger916125tag:blogger.com,1999:blog-8449039.post-42049932671174132842018-04-26T07:36:18.776-04:002018-04-26T07:36:18.776-04:00CSV is text-only, so no, it's not possible to ...CSV is text-only, so no, it's not possible to embed an image.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-44124797493050346562018-04-26T07:35:14.430-04:002018-04-26T07:35:14.430-04:00Hi Scott,
Is it possible to show blob column in th...Hi Scott,<br />Is it possible to show blob column in this export?<br />Am having employee image in my table stored as blob column. I want my csv with employee image too. <br />Please let me how to achieve this with this method.<br /><br />Thanks,<br />NivethaNivetha Ramnathnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-88051902007406928582018-04-19T09:50:41.895-04:002018-04-19T09:50:41.895-04:00Why not just hard-code the column headers and UNIO...Why not just hard-code the column headers and UNION that with the data? You can then add a "sequence" column to both parts of the query and assign a 0 to the header and a 1 to the data, and be sure to ORDER BY that column.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-60400161526829039512018-04-19T09:12:46.186-04:002018-04-19T09:12:46.186-04:00Hi Scott,
Thank you for the post. It is very helpf...Hi Scott,<br />Thank you for the post. It is very helpful. I have a requirement to export the report title and parameter values to the .csv file. Our queries are fairly complex. Some of them have over 60-70 columns and take about 20 mins to render the report itself. Is there a better way to export other than executing the query all over again? We are using version 5.1.3Anonymoushttps://www.blogger.com/profile/03581173796399149687noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-4449572766942332792018-04-06T04:47:16.850-04:002018-04-06T04:47:16.850-04:00Nice ;)Nice ;)Jakehttps://jake.citynoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-36497364106334451652018-04-04T00:21:20.735-04:002018-04-04T00:21:20.735-04:00Appreciate for Your article! Perfect! Appreciate for Your article! Perfect! Sasha Gomanukehttps://www.blogger.com/profile/03294578263789033263noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-65634105086765394452018-01-26T14:52:17.868-05:002018-01-26T14:52:17.868-05:00Hi scott...I added another htp.prn line before loo...Hi scott...I added another htp.prn line before loop with headers and it is working as expected thanks...sreehttps://www.blogger.com/profile/02459417626796911322noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-57150486732244567732018-01-26T14:17:54.159-05:002018-01-26T14:17:54.159-05:00Sree,
The example that I provide only outputs dat...Sree,<br /><br />The example that I provide only outputs data; you'd have to add a line before the loop to output the headers.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-73009496686195079822018-01-25T13:34:32.465-05:002018-01-25T13:34:32.465-05:00Hi Scott, I used your suggestion to get the downlo...Hi Scott, I used your suggestion to get the download but I changed it to .txt instead .csv, but I have an issue ...I am not getting the report headers..all i am getting is data without any headers...this is happening in both csv and txt...any insight?sreehttps://www.blogger.com/profile/02459417626796911322noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-82411759876664095992017-11-10T09:34:29.592-05:002017-11-10T09:34:29.592-05:00Not really; if that's what you need, you can Z...Not really; if that's what you need, you can ZIP the two files up before exporting and then download the ZIP file.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-64126093020909311682017-11-10T09:33:36.163-05:002017-11-10T09:33:36.163-05:00Scott,
Can you export 2 routines in the same CSV ...Scott,<br /><br />Can you export 2 routines in the same CSV file?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-72588983529843310512017-11-10T09:26:26.035-05:002017-11-10T09:26:26.035-05:00Hector,
You can use the bind variable syntax to r...Hector,<br /><br />You can use the bind variable syntax to refer to the value of the items: :P1_ITEM_NAME. However, they may not be set in session state. If that's the case, then you're better off using a Dynamic Action to first set them, and then call the export to CSV routine.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-91222510193731815662017-11-09T18:26:55.190-05:002017-11-09T18:26:55.190-05:00hello scoot, in apex I need to export to CSV a cla...hello scoot, in apex I need to export to CSV a classic report and within the section I have items with some fields, it is required to export items and classic report in the same file, how can I achieve this?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-8361795382922370552017-07-16T13:00:49.490-04:002017-07-16T13:00:49.490-04:00This is regarding an earlier (unpublished) post wh...This is regarding an earlier (unpublished) post where I asked for help with troubleshooting the issue of not getting rows returned from the sample select that you provided. I found the problem was because of an edit I had made to your AWS S3 package that allows support of HTTPS. I had thought one of the constant values was specific to your environment and I changed it. Wrong. So, thanks again for the article and I will now take the next step of trying to get it to work with APEX.Brad Peekhttps://www.blogger.com/profile/15817125526394590143noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-44078203127963894912017-07-15T16:04:24.948-04:002017-07-15T16:04:24.948-04:00To get around the AWS4-HMAC-SHA256 issue, I create...To get around the AWS4-HMAC-SHA256 issue, I created an AWS bucket in the US East (N. Virginia) region, which I think should support the older cypher that your package uses. I get to the point of running "SELECT * FROM table (amazon_aws_s3_pkg.get_object_tab(p_bucket_name => 'my-bucket-name'));" but zero rows are returned. I don't get any error messages, which I think means I am authenticating and also specifying the correct bucket name. For example, if I put in a bogus bucket name I get an error message to that effect. Any idea why that select would not find the documents in that bucket? I tried making the files "public" just to see if it was a permissions issue and have also tried a couple of different IAM users with no luck.<br /><br />I installed the AWS CLI onto my laptop and can list the document using the same IAM user and bucket name. I would LOVE to get this working, so any help would be appreciated.<br />Brad Peekhttps://www.blogger.com/profile/15817125526394590143noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-9153061199224175802017-07-15T10:40:43.589-04:002017-07-15T10:40:43.589-04:00You may want to use a button to call the export, a...You may want to use a button to call the export, and then have a dynamic action on the button that disables it when it's clicked. This way, the user won't be able to click the button again.<br /><br />Hope this helps.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-27819561894284368722017-07-15T10:39:13.155-04:002017-07-15T10:39:13.155-04:00Brad,
Upgrading to 12c is likely the best approac...Brad,<br /><br />Upgrading to 12c is likely the best approach. There is a patch that will add the new cyphers to 11g as well, but it took quite a while for us to get that to work on another instance. You are welcome to pursue that path as well, but you'll have to work with Oracle Support to get the patch applied.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-51944630271278617792017-07-10T12:28:23.142-04:002017-07-10T12:28:23.142-04:00Hi Scott, I know this is an old post, but I'm ...Hi Scott, I know this is an old post, but I'm using kind of the same procedure to export some custom data and need to refresh the calling page (or maybe it's possible to do it for the report region) after it. Basically, I have a report region generated on a sql query which builds a link to call the page that does the export. Once done, I want the calling (parent) page to be refreshed, so the user can't hit the link again a get an error. Any ideas on how can I accomplish this? I'm on Apex 4.0. Thanks in advance for your help. Aníbalnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-63211058792571471252017-07-09T15:45:57.810-04:002017-07-09T15:45:57.810-04:00Scott -- I ran into "The authorization mechan...Scott -- I ran into "The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256", which is discussed here: https://github.com/mortenbra/alexandria-plsql-utils/issues/24?_pjax=%23js-repo-pjax-container <br /><br />My APEX instance is hosted at Enciva.com and is currently Oracle 11. The GitHub issue comments mentions that the Oracle 12c dbms_crypto package has added HMAC_SH256 support. I can ask Enciva to upgrade my instance to Oracle 12c, but was wondering what else I would need to do to make this work? Not sure I have the skills or patience for a major change to the packages that Morten and you have so generously provided.<br /><br />Did you also run into this issue? Find a solution?Brad Peekhttps://www.blogger.com/profile/15817125526394590143noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-82869824591429328922017-07-05T21:39:16.309-04:002017-07-05T21:39:16.309-04:00Same difference; anything to load a page on that d...Same difference; anything to load a page on that domain will do it.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-91652391386817482042017-07-05T21:24:42.374-04:002017-07-05T21:24:42.374-04:00Thanks. That probably would have worked. What I...Thanks. That probably would have worked. What I did was "open" a text file from the S3 console and exported the certs from the resulting URL. It appears to have worked, although I won't know for sure until I get further along. Brad Peekhttps://www.blogger.com/profile/15817125526394590143noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-18127668056283028982017-07-05T19:56:49.575-04:002017-07-05T19:56:49.575-04:00Brad,
Use this URL: https://s3.amazonaws.com/buck...Brad,<br /><br />Use this URL: https://s3.amazonaws.com/bucket_name/foo<br /><br />Even though the access is blocked, you should be able to get the certificate from that page.<br /><br />Thanks,<br /><br />- Scott -<br />Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-761480132604813412017-07-05T19:52:41.310-04:002017-07-05T19:52:41.310-04:00I'm going to give this a try, and really appre...I'm going to give this a try, and really appreciate the article. You mention that in order to create a wallet with the correct certificates I would need to get them from s3.amazonaws.com. Has this changed since you originally wrote the article? I get a redirect to https://aws.amazon.com/s3/ when I try it and I'm not sure if that is correct (don't want to assume).Brad Peekhttps://www.blogger.com/profile/15817125526394590143noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-9310332757819023392017-03-24T08:47:39.186-04:002017-03-24T08:47:39.186-04:00John - excellent points. Small, citizen-developed...John - excellent points. Small, citizen-developed systems WILL become mission critical, as there is no translation gap between implementation and requirements. A shoddy-built ABCS application will be more popular than a custom developed solution, as it's more likely to capture what the users need - even though it could be more difficult to use.<br /><br />I see this more like Designer - you can certainly take the generated PL/SQL and make changes, but the second you add one character, you can no longer generate new changes from the tool. So yes, there is a way to transition an application from citizen to professional developer, but it's not painless, and my fear is that users will do all they can to keep things under the radar, which could be dangerous.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-22152605605461280362017-03-24T08:44:06.149-04:002017-03-24T08:44:06.149-04:00You expressed my concerns well about Oracle's ...You expressed my concerns well about Oracle's new Oracle Application Builder Cloud Service, which I mentioned to Oracle's Product Manager. I saw a demo, and it looked great, easy to use, lots of capabilities. Perfect for the "citizen-developer". But, I said to the PM, "What happens when the requirements outstrip the capabilities, or when a neat application developed by a non-professional needs to go business-wide?" Can a professional grab the underlying code to maintain and extend it? The underlying code is apparently Oracle Jet, which gives me hope, but is the generated Jet code readable so that a pro has a chance of modifying it? And can we even get to the code?John Flackhttps://www.blogger.com/profile/07116756139055371171noreply@blogger.com