Search results for query: *

Perhaps you need to schema qualify the table? Regards, William Chadbourne Programmer/Analyst

Hi, Soushi01 Oracle reports earlier than 9i will not recognize CASE statements internally. You could probably get it to work from within the database. William Chadbourne Programmer/Analyst

What is the database version? William Chadbourne Programmer/Analyst

Why don't you write a REF CURSOR package? I had to do it for a Crystal Report that needed to be able to define parameters before the report was run William Chadbourne Programmer/Analyst

Hi, IQ First of all are you running this from the host (application server) or from the client (local PC)? Regards, Bill Chadbourne William Chadbourne Programmer/Analyst

I didn't. It puts the saved report name there automatically. William Chadbourne Programmer/Analyst

This is from the official Crystal Reports documentation: In order for Crystal Reports to report off Oracle stored procedures, all of the following requirements must be satisfied: • To use an ODBC connection to access an Oracle stored procedure, you must create a package that defines the REF...

Did the package I uploaded help in any way? Regards, William Chadbourne Programmer/Analyst

Greetings, nkshah This package is used in a Crystal Report for the purpose of allowing the user to select how many "bars" a user wishes to see in a bar graph report. This is the package spec: CREATE OR REPLACE PACKAGE ANALYTE_HISTOGRAM...

I have a package I created to do this for a Crystal Report which I will upload when I get to work. I'll add comments to explain what is going on. Regards, William Chadbourne Programmer/Analyst

Yes, because Crystal will only recognize a table or a view so in order to use a package (Crystal will not work with a procedure) it has to return a REF CURSOR which Crystal will interpret as a table. Regards, William Chadbourne Programmer/Analyst

Actually, it doesn't. I have to manually change it in the File->Summary Info. William Chadbourne Programmer/Analyst

Greetings, I am using Crystal 10. If I have a report open and I want to save as a report with a different name, the name in the window bar in the top left hand corner still has the name of the original report. I know that if I select File->Summary Info from the menu bar then I can save it...

Greetings, Are you using Oracle Application Express as well? Regards, William Chadbourne Programmer/Analyst

Hi, Dave Looks like exactly what I need Thanks, William Chadbourne Programmer/Analyst

Hi, Dave Perhaps I should have been a little more specific. I need a function to do this. It actually runs from an Oracle form. When the user types the address in and let's say that they type in "Lane" as soon as they exit the form the "Lane" is converted to "Ln". Thanks, William...

Greetings, I need to be able to replace street names with their abbreviations. For example, 123 Maine Street would become 123 Main St If I use the REPLACE function it replaces all occurrences. For example, 123 Lanes Lane would become 123 Lns Ln Any help would be greatly appreciated...

Greetings, You will probably have better luck if you post this in the Oracle: Designer forum. Regards, William Chadbourne Programmer/Analyst

Greetings, Not knowing about your first option, I can say that I like using APEX. If you use Oracle 11g or 10g database express you do not need to have a HTTP server as it were. Oracle uses what is calls a "PL/SQL gateway" to handle that. And the best part is that it is FREE!! Regards...

Greetings, You can export to 10g if the 8i version is 8.1.7.4. Regards, William Chadbourne Programmer/Analyst