Recent Posts

Pages: 1 ... 7 8 [9] 10
81
PSOUG / Re: Where are XSL files to be stored?
« Last post by Mike on June 23, 2014, 01:43:19 PM »
I don't know if this is of any help, but a quick google search found this:

http://docs.oracle.com/cd/E38689_01/pt853pbr0/eng/pt/tibr/task_DevelopingTransformsUsingOracleXSLMapper-0762e1.html

Also this page shows some info as well:

http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/design_xsl_sub.htm

14.4.1 Importing the Subtemplate

Enter the import command anywhere in the main template prior to the call template command as follows:

<?import:xdoxsl:///{path to subtemplate.xsb}?> 
where
path to subtemplate.xsb is the path to the subtemplate .xsb object in the catalog.

For example:

<?import:xdoxsl:///Executive/Financial Reports/mySubtemplate.xsb?> 
82
PSOUG / Where are XSL files to be stored?
« Last post by SMerrill8 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?
83
PSOUG / Re: ORA-01422: exact fetch returns more than requested number of rows
« Last post by Mike on June 17, 2014, 01:37:57 PM »
Thank you, Prakash!

We've added this information into the error code listing for the ORA-01422 error.
84
PSOUG / Re: ORA-01422: exact fetch returns more than requested number of rows
« Last post by Prakash on June 17, 2014, 09:21:00 AM »
In addition to above details to this error/exception:

ORA-01422: exact fetch returns more than requested number of rows

By default, a SELECT INTO statement must return only one row. Otherwise, PL/SQL raises the predefined exception TOO_MANY_ROWS and the values of the variables in the INTO clause are undefined. Make sure your WHERE clause is specific enough to only match one row

If no rows are returned, PL/SQL raises NO_DATA_FOUND. You can guard against this exception by selecting the result of an aggregate function, such as COUNT  or AVG(), where practical. These functions are guaranteed to return a single value, even if no rows match the condition.
85
PSOUG / Scholarship offering for Women Technology students in Puget Sound
« Last post by RSmithBothell on May 07, 2014, 05:30:16 PM »
The Association of Women in Computing, Puget Sound chapter annually offers two $1000 scholarships to two women attending school full time and pursuing a computing-related degree.

I'm the Scholarship director and the contact for this offering.  I'm also a member of this group and wanted to share this because I know that some of us might have an eligible daughter in school in the area.

If you have any questions please reply to this posting and I'll be notified.

This URL to follow includes www (dot) awcps (dot) org (slash) scholarships, has all the info needed for a student to find out more, and how to apply.


Thank you!

R. Smith
Scholarship Director
86
Oracle News / Ask Tom: On Oracle Database 12c, Part 5
« Last post by Mike on May 01, 2014, 05:01:27 PM »
Ask Tom: On Oracle Database 12c, Part 5
1 May 2014, 4:31 pm

Our technologist--Tom Kyte--explores the invisible, improves introspection, and expands SQL.

Source: Oracle Magazine - Most Recent

87
Oracle News / Cover Feature: Ground Control
« Last post by Mike on April 30, 2014, 11:01:10 PM »
Cover Feature: Ground Control
30 April 2014, 4:31 pm

Oracle Cloud Application Foundation solutions launch your cloud applications.

Source: Oracle Magazine - Most Recent

88
Oracle News / Oracle Magazine May - June Issue
« Last post by Mike on April 28, 2014, 05:01:15 PM »
Oracle Magazine May - June Issue
28 April 2014, 4:29 pm

Oracle Magazine May/June includes articles on Oracle Cloud Application Foundation; an interview with Nandini Ramani, vice president, Java Platform and Internet of Things  at Oracle; Bob Rhubart on being an architect; Mark Rittman on Oracle Data Integrator 12c; Oracle SQL Developer Data Modeler; Arup Nanda on Oracle Partitioning; Steven Feuerstein on SQL in Oracle Application Express; Tom Kyte On Oracle Database 12c; Partner News; Book Beat and much more

Source: Oracle Magazine - Most Recent

89
PSOUG / 6508 ORA-06508: PL/SQL: could not find program unit being called
« Last post by Prakash on April 24, 2014, 10:59:56 AM »
Perform the following to mitigate this error.

1] Compile the package again with alter command.
2] Drop and recreate the package
3] Disconnect and connect the session again.
4] Stop and start the services on the application server/web server.
5] Check if any objects have changed in the signature of the procedure being called.
90
Oracle Security Alerts / Oracle Security Alert for CVE-2014-0160 - 18 April 2014
« Last post by Mike on April 22, 2014, 08:10:12 AM »
Oracle Security Alert for CVE-2014-0160 - 18 April 2014
18 April 2014, 1:30 pm

Oracle Security Alert for CVE-2014-0160 - 18 April 2014

Source: Oracle Security Alerts

Pages: 1 ... 7 8 [9] 10