Search results for query: *

This error message is telling you that it found a reference to the database in your local name directory (TNSNAMES.ORA or Oracle Names or network directory service) but it couldn't connect using the protocol specified. There can be many reasons for this, but some of the most common are: Wrong...

Why fix this the hard way? Go into the Repository Administration Utility, and press the Recreate button. One of the options under that button is "Recompile Objects". Select this, press Start, and it will recompile everything, and will stop if there is a problem.

One of the things I hated most about the transition to Designer 6i is the way they broke all of my API reports and utilities. The API hasn't really changed much, but what has changed has a far reaching effect - the primary keys. For most purposes, the new PK is the new column, IRID. If you...

I presume that you mean that you are generating Oracle Forms and Oracle Reports. If so, then you can buy a copy of Oracle 9 iDeveloper for Linux. Then all you have to do is move your .fmb (or .fmt) and .rpf files to your Linux computer (use a binary file transfer), and compile them with the...

Your diagram required more space than was available for the Repository. Tell your DBA that you need more space in the DIAGRAM_INDEXES tablespace. S/he should know what to do. Ask her/him to check the space in the rest of the tablespaces while s/he's at it - if one is hitting the edge, chances...

sem probably has your answer, but it is a good idea to include an exception handler, especially when you use UTL_FILE. Do this: EXCEPTION WHEN UTL_FILE.INVALID_PATH THEN DBMS_OUTPUT.PUT_LINE('Invalid path: /usr/users/awilli02/sql'); ... END; Check the supplied packages manual for the...

karluk's response was correct, an end of file condition will cause a no_data_found exception. mesuj's code won't quite work, because it doesn't handle the exception. Many people don't like this, so they write their own package to wrap UTL_FILE.GET_LINE and UTL_FILE.GET. My version turns...

A lot depends on whether you are using the logical design tools, such as the E/R modeler, or the physical design tool, the database modeler in the Design Editor. If you use the E/R modeler, just draw the entities and relationships. As you add attributes to the entities, you can designate some...

We normally do what you want by loading a staging table with SQL*Loader, and using SQL or PL/SQL to get the data to its real destination.

Certainly you can, but to do it, you have to widen the swim lane. Just select the organization block for the swim lane that you want to widen, hold the SHIFT key, and press the DOWN arrow to widen, or the UP key to narrow. You can only narrow the lane if there is nothing in the area that you...

When you say FROM and TO, I presume that you are drawing relationships. What you ought to be typing in those fields is not the names of the entities (tables), but the names for each end of the relationship. Read the relationship like this: Each (name of the FROM entity) "may...

I just noticed that this BBS tries to turn my web addresses into links, and doesn't do a great job. Here they are again: NY OUG - http://www.nyoug.org Technet - http://technet.oracle.com Oracle Magazine - http://www.oramag.com My web site - http://www.smdi.com/employee/JohnF/orastuff.htm

While EXP can be used to save DDL, and you can use IMP to write that DDL to a file, the DDL gets chopped up, and it takes a bit of editing to get it into executable form. There are many good SQL*Plus scripts for doing this, and many of them are freely available for download. For instance, one...

My Spanish is good enough to get the basics of your question, but not good enough to give you a reply in Spanish, so I hope you or somebody near you can translate. In the manual, there are instructions about privileges that must be granted to the repository owner before you can install the...

Do you have access to a C compiler? (or COBOL or some other language with Pro* support) If so, I'd say that unless this is a one-time project you might want to use a 3GL with Embedded SQL. This will almost certainly perform better than UTL_FILE. I'd use SQL*Loader if you don't have a lot of...

Can you be a bit more specific? Are you generating MS-Help? Table data for Forms-based help? Chances are that you need to change help in Designer and re-generate, but I'd like more info to know for sure.

Softdrink - I'm afraid that you've been given bad information. Developer 6.0 must be installed first, in an Oracle Home directory designated as DEFAULT_HOME. Then you can install a database in some other Oracle Home. At this point, you may have to clear Oracle off your machine and start over...

You need to get that password from the person who installed Designer. He/she may need to grant you privileges.

What you want to do is perfectly possible. A cursor is simply a program's pointer into the results of a SELECT. SELECT returns a result set from one or more tables, but most 3GL programming languages, including PL/SQL, can only work with one row at a time. So a cursor points at that row...

The built-in packages are well documented in the Oracle Supplied PL/SQL Packages Guide. This document is obtainable in PDF format from http://technet.oracle.com. If you don't want to do a SELECT from ALL_SOURCE, look in %ORACLE_HOME%/RDBMS/SQL at the various package specification files called...