I am looking for a database technology to use, I will try to describe
the situation.
The system is a loan originating system, using Magic 9.3sp2 (RAD
tool), direct sql commands and lots of packages. The money flowing

Hi, I'm trying to get the following package to compile, but I keep
getting cryptic error messages... Please help!
SQL> CREATE OR REPLACE PACKAGE BODY AUDIT_PKG
 2  AS

Can someone please explain what these two statements in a PL/SQL block
mean? Thanks for your help
TYPE plist_id_tab IS TABLE OF tmp_profile_tbl.plist_id%TYPE;
plist_id_tbl plist_id_tab := plist_id_tab();

I just upgraded to a new 64-bit workstation with Windows XP Pro 64 (AKA
Windows XP 2003) and after several attempts got the Oracle 9i client
installed, or so it appears.  The Oracle provided ODBC drivers also
appeared to install.  I created a TNS Net Service Name successfully.

I'm looking for some example questions and answers concerning oracle
1z0-007.
Thanks
Caveman80

Hi,
I had recently visited the uCertify site. They are offering 50% discount
on their exam simulations for Oracle certification. But I don’t know how
long it will continue and is it worth buying those exam simulations, can

OK, I'm running 9.2.0.1 on HP-UX 11i, and I'm trying to create a java
object using:
create java class schema pt using BFILE ('/home/oracle/pt' ,
'SiemensForeignObject.class') ;

I have stored procedure with a statement like this:
TYPE mylist IS TABLE OF table%ROWTYPE;
enums mylist ;
select name from table

I am getting a casting exception (java.lang.ClassCastException:
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection) when invoking the
CLOB.createTemporary metehod.  Extract of relevant lines shown below:
Any

I have a problem when passing values greater than 32K througn pl/sql
procedure arguments with Oracle 9i.
How can I do to pass large amount of data through pl/sql procedure
argument and go over this limit?

  I have a table which contains over 30 million rows of data (over 50
columns). I need to write all the data to a flat file with specified
delimiter, header and output file name. Which tool is the fastest for
this task? I can think of tools such as PL/SQL UTL_FILE package, Java

i'm sorry but i forgot,... i'm using a 9.2 version of oracle
"fdsarty" <dsasdgf@yfdsasdfdo.it> ha scritto nel messaggio news:...

                                                    AIM EXECUTIVE
                                                 tgugger@aimexec.com
                                                       419-380-8853
                       ORACLE/ ASCP/ DEMAND PLANNING/ FUNCTIONAL

my application use jdbc thin driver to connect to my database. After
some time I got ORO-17401 Error with following description:
protocol violation.
Nothing more!

The EXPLAIN PLAN for this:
update hse.colour set chs_uid = (select librarycolor_id from
chs.librarycolor where upper(librarycolor.colorcode) =
upper(colour.colcode));