Search results for query: *

My client has a procedure in a package that has an IF statement that is repeated in four separate places. It reads something like this:IF v_code IN ( 'CA','CF','CN','CT','JO','ND','NT','P1','P3', 'PA','PB','PC','PD','PE','PF','PH','PJ','PK'...

I have Oracle 10(g 10.2.0.1.0) installed on my PC. My problem is that when I start an OC4J listener and then try to run a form from Forms Builder, the browser opens to a white page that says "ORACLE FORMS." and then stops. My Forms Builder Runtime Preference for Application Server URL is...

I have inherited a set of PL/SQL coding standards written in 2007 for an Oracle 8i database. My task is to make recomendations to update these standards for 10g. While I am sure I might have more later, right now I have two questions. 1. The original standards state that public procedures...

I have a function in a package that returns the name of the database to which a session is connected by returning GLOBAL_NAME. This has worked well for the past three years. When a testing script is run, the database, date, time and description are displayed: HSDEV 04/09/2009 03:41:28pm...

I found this bit of code in a package whose SQL I am reviewing: FROM ch_entity i, rf_perf t WHERE i.ch_entity_type = 'INSURER' AND t.insurer_id(+) = i.ch_entity_id AND t.ipsmry_id IN (SELECT ips.inspsmry_id FROM inspsmry ips WHERE...

Embaressed by yor spelling? Never you mind. Fed up with his students' complete inability to spell common English correctly, a British academic has suggested it may be time to accept "variant spellings" as legitimate. Rather than grammarians getting in a huff about "argument" being spelled...

I am generating a fairly simple report in SQL*Plus and having an unusual problem. The line of hyphens (the SET UNDERLINE character) that separates the heading from the data is being truncated to 100 characters. My login.sql: set termout off define my_version='0.0.0' column my_version new_value...

I would share this as we might have some good contributors in our TT ranks: The Cliche Rotation Project I submitted: Old - Hot topic New - Sizzling Subject Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports &...

I really could use a pair of fresh eyes to look at what should be a simple matter. I have a package that opens a cursor and should return data from one row at a time. However, in testing it does not recognize that the cursor is open on the second time in and reopens the cursor.CREATE OR REPLACE...

As an Oracle developer, I work with documents that reference Oracle reserved words, table and column names like INSERTED_DATETIME. The underscore is commonly used to separate words. When I double-click, Windows selects: [tab]INSERTED_DATETIME What I really need selected...

I receive a daily "Word of the Day" email from the Merriam Webster web site. Today's word is: Semiquaver, I understand. Demisemiquaver, maybe. But hemidemisemiquaver is prefix overkill! Can you think of any other examples? Beware of false knowledge; it is more dangerous than ignorance...

I was researching packages and found: My client has a large package that contains over 5000 lines of code and 19 procedures all relating to updating various bits of data in the database pertaining to a person. None of these procedures rely on each other. There are no variables in the package...

Is there a best practice rule-of-thumb regarding using DECODE when a simple NVL would do? I am trying to convince my client that something this:UPDATE address SET county_code = decode(rec.county_code, NULL,county_code...

Once again I have to find a back door approach to do my job due to lack of privileges - arrrrghhhh! The DBA group has decided that developers, in the development database, can see the source of procedures and functions, but not packages. Don't ask why, I don't know. They only say that if I need...

This is a very basic question. I have a procedure with approx. 40 parameters. I want to call it but provide only the values that are absolutely necessary. I have tried this: p_insert_push ( return_code => v_return_code, return_key => v_return_key, in_action_code...

I am currently working a state contract that geared up before the project was really ready to start. I have a manager who has very little time between meetings and production problems. The net effect is that I often finish the few work orders given me and sit idle, sometimes for days. How does...

Not too long ago I started the thread "Favorite Quotes". In a separate thread I was startled to see a conversation that the title should have been "Favorite Quotations". The gist of it was that "quote" is a verb and "quotation" is a noun. I was mortified to have made that mistake in a forum...

Many of us here at TT have quotes in our signature lines. Some funny, some profound (like CC's) and some personal. The problem I have is that I do not have the time, or inclination, to change the quote in my signature on a regular basis. That being said, I would like to post another of my...

In the Word Of The Day on My Yahoo today: Can someone explain how the second example of "florid complexion" applies? Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows) My website...

Merriam-Webster Inc., publisher of a leading U.S. dictionary, is asking visitors to its Web site to pick: The One Single Word That Sums Up 2006 Get your vote in by December 4th. I have to give this one careful consideration. Your suggestions? Beware of false knowledge; it is more dangerous...