i am trying to call a function inside a package. (basic operation)
I do not have the package source and it is wrapped, so i can't see the
source.
the doc only say:

If I have a SQL statement:
-----------------------------------------------------
update TRAIN_ROUTE_MQ TRMQ
set    (TRAIN_I, P_VERSION_I) =

I notice that on my new pSeries AIX 5L/5.2 box
that there are no library environment variables
defined by default.
The vars I'm talking about are LIBPATH and

www.FindJobEasy.com is a job search engine. Multiple jobsites will be
searched just by one simple click. The online job search option will
search 12 popular job sites online. You can also leave search criteria
and get an e-mailed job list with job search results from over 50 job

Hey all.
I'm reasonably new to Oracle, and am currently tasked with working to
move from the RBO to the CBO in our environment.
I just read through the article "THE SEARCH FOR INTELLIGENT LIFE IN THE

  I have a list of values,
('a', 'b', 'c', 'd')
and I am trying to find out which of those values is NOT  in the list
returned from this query

Should I write this in a flash mx group instead, I couldn't decide.
Can I run a procedure or a trigger in oracle db from Flash mx?
Should I use XML to connect flash and database?
I want to hit a button in a .swf file and update database or retrieve

I was  told that MD5 function is available in the DBMS_OBFUSCATION_TOOLKIT
package.  However, I looked up the Oracle9i Supplied PL/SQL Packages and
Types Reference (R9.2) and there are only 4 DES/DES3 encryption/decrypt
procedures - no md5.

Something weird with a user
He connects with sqlplus , he has the following error:
ERROR:
ORA-00604: error occurred at recursive SQL level 1

we have several offices use Comcast cable modem
through VPN connect to ORACLE server (9iR2).  Those
offices have same problem almost every 20 to 30
minutes ORACLE client disconnect.

I am having some difficulties doing a full import of a database from a
10.1.0.2.0 instance running on Win XP to a 10.1.0.2.0 instance running
on Solaris 10.
The tablespaces have been precreated using the same scripts in each

Problem with conection.
The simple 10$ router in the lan is blocking ports.
I've oracle listener on serwer and clients set on port 1521.
The connection is -- time out what to do.

I have a view base on three columns( ID, historical_date, value)
The view is built like this:
select * from hourly_data
Union

Our RMAN configuration runs each hour, backing up the archive logs and
them deleting the log itself.
Well, the need has arrisen for us to mine to logs.  I assume that I can
restore the archive logs without applying them right?  We are running

I have a bunch of files accumulating in the ORACLE_HOME/dbs
directory. They look like this:
-rw-r-----   1 oracle   dba      8716288 Jan  2 10:46
c-1243799354-20050102-06