Blog

Syntax Highlighting for PeopleSoft SQL Traces

Created on Friday, 09 July 2010 18:02
Written by Larry Grey


This is an update to our Editing Enhancements for PeopleCode and SQR blog entry, and was covered in one of our recent webinars for learning to be an expert in PeopleSoft.

One of the things you'll notice if you go through a PeopleCode trace is that there's way too much detail if you're trying to learn what's going on under the covers. We've found that if you can navigate to the page you want to learn about, turn on tracing, perform a few actions, and then review the trace, you'll pick it up a lot faster. The real question is how to do it.

Well, there's really two pieces:

  1. Providing a way to turn tracing on and off right at the point in which you want to record your SQL
  2. Provide a way to more easily review the SQL trace generated by PeopleSoft

So, we've put together an iScript that has the tracing in it for SQL as well as PeopleCode tracing as well as extending the user defined language file that already has PeopleCode and SQR syntax highlighting in it for SQL traces.

How to get it

Well, the PeopleCode can be accessed here.

The syntax highlighting file can be found here. To apply the syntax highlighting to Notepad++, merely go to %APPDATA%\Notepad++ and overlay the userDefineLang.xml file that's there.

Limitations and Enhancements

The current set of limitations and enhancement requests for this example can be found here.

Labels: , ,

peoplecode | sql | trace

Comments (7)
7Thursday, 16 June 2011 23:11
Chris Malek
Great Idea!
6Thursday, 16 June 2011 23:09
Neeraj Kholiya
Hi sir

But we have the online audit setting ( peopletool -- utility - administration -- debug ) through that we can put the dynamic trace too...
5Thursday, 16 June 2011 23:08
Kiran
The code highlighting is neat. One scenario it does not recognize as a comment is, when the comment is like this -

/********************************************************************
Added by developer on Reading data from input file, validating the data and inserting into a component record using CI.
********************************************************************/

It gets recognized as a comment in App.Designer though!!!
4Thursday, 16 June 2011 23:07
Chris Heller
Thanks Kiran, I opened a ticket to track this.

http://code.greysparling.com/ticket/22

You can track it's status there by it's RSS feed (see the bottom of the ticket). You can add yourself to the cc list for the ticket if you register yourself for an account. If you're on the cc list, then you'll get emails for activity on the ticket.

http://code.greysparling.com/wiki/RegisteredUser
3Thursday, 16 June 2011 23:06
kane81
So after installing the 'Turn on or off Tracing from URL' into the system, how do I actually use it / invoke the calls to turn things on and off while on a page?
2Thursday, 16 June 2011 23:05
kane81
Hi Again

So after installing the package, how do I enable or disable tracing when I am viewing a page?

Thanks

Kane
1Thursday, 16 June 2011 23:04
Chris Heller
Thanks Kane, it looks like the bookmarklets to invoke the iScripts were not checked in with the project. You can track this here.

http://code.greysparling.com/ticket/26

Add your comment

Your name:
Comment:
yvComment v.2.00.2

News Archives

Recent Comments

Tags

2007 2008 2009 2010 bolt-on drilling events java ldap mobile nvision openworld peoplecode process_scheduler products query reporting security support sysadmin telephony testing upgrade versioncontrol webinar

Get in Touch

This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

+1 925-217-1298 x 201

Oracle Partner

© 2011 Grey Heller Solutions.
All rights reserved.