I'm pretty new to pl/sql and having trouble passing exceptions between
my sql and procedures.
I have my basic sql:
begin

I need to completely uninstall PL/SQL Developer from my machine.  
What are the keys stored in the registry for PL/SQL Developer?  
Any ideas on how I can remove them efficiently?
Thanks

I'm trying to install Developer 1.3.3 on Windows 2000.
After install I can't connect to the database (Oracle 7.2.2) I get the
error message:
'f45des has caused a general protection error in module sql16w95.dll in

I have created a table type called num_tab as table of numbers.
(create type num_tab as table of number)
I use this table type in a function to temporary store a list of
numbers which is used in a where clause of a separet query.  It works

Preamble: I did post this initially to comp.databases.oracle, but found
an article indicating that it was basically a dead group, serving as a
pointer to the more defined groups. Thus, I posted in error, and
believe this is the appropriate group to ask the following question. I

I just installed Oracle 10g developer tools on an XP Pro machine.
Everything connects OK. When I use the data block and canvas wizards,
the database tables appear and everything seems to work fine. However,
when I try to do the "run form", a new browser window pops up with text

I have downloaded 9.2.0.1.0 of Oracle and am currently trying it out.
In these groups I see refererences to SQLLoader.
Where do I find this tool? I have looked in the various Oracle
directories, but cannot find it!

Hello all. I just installed the full Oracle 10g developer tools on a PC
running Win XP Pro. I had 9.2 client on it before and it worked fine.
The installation was successful and I then ran the net configuration
assistant. The connection test was successful. However, when I try to

how I can set an ID for my 10g database? I need it for my recovery!
I tryed:
connect / as sysdbaSHUTDOWN IMMEDIATE
STARTUP MOUNTnid TARGET=sys/password@OracleTestThen comes the error

I was recently asked to resurrect an Oracle project shelved
several years ago.  I know almost nothing about Oracle.  So,
I barely know where to start.
There is a windows application that connects to an Oracle server

My company needs to install Oracle forms. I am a DBA, so I have no
experience with forms. I was hoping someone could answer come questions
for me.
We are running Oracle 8i on HPUX 64, so from what it looks like, I'm

Im wondering something...
I had a colleague who made a form (master block and a detail block)
that does an update ((plsql) on a record of the detail) on the previous
record's ending date minus a day of beginning date of a new record

This is the code which i use to test connecting to Oracle db.
But it says "Exhausted Resultset"
         System.out.println("Connecting...");
          Connection conn = DriverManager.getConnection

Hi NG,
I'm looking for a possibility to show all SQL-Statements (testsystem)
in realtime. (Ora 9i R2 Enterprise).
In MSSQL Server 7.0 this tool called SQL Trace and in 2000 called

Hi, I am reading document B10825-01.pdf Oracle Database Utilities, chapter
20 "Original Export and Import". I am an aspiring DBA but not a DBA.
My understanding from B10825-01.pdf is that to export all the tables, stored
procedures etc for SCOTT, I would use this: