Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - SMerrill8

Pages: [1]
PSOUG / Re: Where are XSL files to be stored?
« on: June 23, 2014, 01:49:51 PM »
Thank you Mike - I already found those pages, but I don't have Oracle Business Intelligence Publisher or Oracle JDeveloper at my disposal.  I only have Oracle SQL Developer and Visual Studio 2010 with Oracle Developer Tools for Visual Studio (ODT) installed.

I'm looking for the simplest solution - hand-coded.

PSOUG / Where are XSL files to be stored?
« on: June 23, 2014, 01:34:37 PM »
I would like to program an Oracle 11g stored procedure to mail-merge and transmit html e-mails to our clients.

However, the XSL code I have written is necessarily larger than 4000 characters so I think it must be stored in a file.

At my company, I am a Developer, not a DBA.  so I need to request of our DBA team to upload my XSL file to someplace on the server such that the stored procedure may see the file and use the content.

I will then try to find code on the web someplace which does the transform from XML to HTML.

This is a medium-volume mailing.

What do I tell my DBA team to do?

Pages: [1]