Save time in programming and testing
Get an in-depth view of your program
Improve code quality
Even well-designed programs can conceal obscure bugs and inefficiencies.
Stop wasting time and cluttering your programs with #DEBUG and SHOW statements.
Discover what your program is really doing, as it does it, in real time.
SP Debugger for SQR is a flexible, easy-to-use tool that helps you
monitor and interact with your program on a line-by-line basis. It's an affordable solution
that could pay for itself in time savings with your next program fix.
Buy it or view pricing and options
System Requirements
• Windows XP SP2, Windows Vista, or Windows 71
• Brio/Hyperion/Oracle SQR 4.3+ or PeopleSoft SQR
• Oracle, MS SQL Server, Sybase, or ODBC database
• Two-tier database access2
• Microsoft .NET Framework 2.0+3
Frequently Asked Questions
Is Unix supported for interactive debugging?
No—this is a Windows program. However, we have many customers who use Unix for their production SQR processing.
These customers develop and debug their SQR programs on Windows PCs and then migrate the final code to Unix.
There are no plans to develop a native Unix version.
Can the program be run from a shared network drive?
Yes, although we strongly recommend that you install it locally on your own PC.
During debugging sessions there is I/O traffic that is handled much more efficiently when the
program is installed on your PC.
Can the program be run on a remote access or Citrix® server?
Yes.
Does the debugger support PeopleSoft® systems? Is PeopleSoft required?
The debugger does not require PeopleSoft, but any PeopleSoft version is supported as long as your SQR version is 4.3 or higher.
Can programs be debugged from the PeopleSoft menu (or portal or Process Scheduler)?
Programs run through the debugger are run outside of the PeopleSoft system.
This question is related to PeopleSoft run control and how an SQR program receives run control parameters.
The debugger can supply these parameters, simulating a run under Process Scheduler in such a way that your SQR
program can't tell the difference. The setup for this is explained in the help file.
Does this product include the SQR language compiler/interpreter?
No. SQR is a separate product that is a part of Oracle® Production Reporting and is bundled with various other products.
For information, contact Oracle Corporation.
We have several developers working remotely. Would a site license apply in our situation?
It may—please contact us to see what type of licensing is best for you.
I am a consultant. Can I use my licensed copy of the program at my client's site?
Yes. (Remember to uninstall it when your assignment ends.)
Will this product teach me how to develop SQR programs? Is it a tutorial?
No, that's not its purpose.
Selected Customers
Licensed users of SP Debugger for SQR include public and private sector organizations of all sizes in a wide variety of industries. Here is a partial list:
Our Customers Say...
"I really do love your debugger and wonder how I was able to develop without it.
Thanks for making such a great product."
"This tool will make doing the work of 3 people manageable."
"I have used the debugger for many years now... Many thanks for such a useful product."
"What a pleasure it is to step through code and watch both the program execution and
variable assignments. This thing is really slick!"
"Love your debugger! It's one of those programs that pays for itself many times over."
"I need to let you know I love your new version. It remains a wonderful tool, and the
new features are very helpful."
"I'm happily using SP Debugger daily and haven't had any issues. So many thanks
for such a useful and stable product!"
30-day Free Trial Download
For an evaluation copy, simply fill out the form below.
The evaluation version is identical to the licensed version and will function for 30 days.
Instructions for downloading the program will be sent to your email address.
Once you receive the instructions, you can have the program installed in about five minutes. No reboot is needed.
We hope you will find the product useful!
Thank you. Instructions have been sent to your email address, "".
If you did not receive this email, please check your bulk or spam folder as it may have been filtered out by your email system.
Thank you for your interest. However, you have previously downloaded the program
on at least two different occasions. If you need an extension of the evaluation period, please contact us by email.
This is just an attempt to filter out some of the spam bots, plus those who know nothing about SQR and would only be confused by the download.
Thank you for your order!
Within 24 hours you will receive instructions for downloading and installing the program. These instructions will be sent to the email address you provided below.
If you have any questions before then, please contact us.
Pricing
First user license: $385
Additional licenses: $265 each
Unlimited users at 1 physical site: $1,975
Licensed per client machine. Delivered via electronic download.
Includes e-mail support and free point release updates for 1 year.
No annual licensing fees. Price shown is a one-time licensing cost.
Prices quoted in USD.
Nonprofit/educational discount: 20% (see below).
To use a purchase order, email it to
or fax it to (480) 247-5349.
To use a credit card or PayPal account, please use the form below.
Purchase Online
Other Information
Interested in multiple-site licensing? Need a quote, W-9 or other information? Please contact us.
Terms of Use
By using this site, you agree to the following Terms of Use.
The information, services, and assistance provided on this site are necessarily general in nature and are provided AS-IS AND WITHOUT WARRANTY OF ANY KIND WHATSOEVER. Because of great variations in individual circumstances, no assurance can be given that the information, services, and assistance provided on this site will be accurate or complete with respect to any user's particular system or applicable to any particular installation or situation. ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE, ARE EXPRESSLY DISCLAIMED.
By using this site, you agree that none of the providers of the information, services, or assistance on this site will be held liable for any damages, liabilities, costs, expenses or special, incidental, consequential, punitive, or exemplary damages (including, without limitation, any lost revenue or profit, even if the person or entity has been advised of the possibility of such damages) related to or connected with the information, services, or assistance you obtain from this site.
We use third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, click here.
HOME
FEATURES
REQUIREMENTS
FAQ
CUSTOMERS
DOWNLOAD
BUY NOW
CONTACT US
Step through your program one statement at a time
Set and clear breakpoints; run to the next breakpoint
Step over an entire procedure, or step through it
Watch the debugger "auto-step" through your code
Pause program execution at any time
Rerun the program from the beginning
Force a database COMMIT at any time