I had the DBA install DBMS_PROFILER in one of our 9.2 databases,
including the 3 corresponding tables in my own schema, but every time I
try to use it, I receive:
SQL> begin

For my first web-driven application I have to use PL/SQL and Oracle
database. I'm on my third re-write and still running into walls. This
is a rather complex system utilitzing 6 pages of forms, with each page
accessing two or three tables at a time. I need to be able to find,

given a table
create table product
(
product_id integer primary key,

     My company just recently purchased Arcserve 11.0 with Oracle
Client Agent to perform backup for our Oracle Database. However, I am
not able to expand the oracle database to see the tables in Arcserve.
It will just keep prompting for username and password. I'm pretty sure

I have a problem running performing silent installs and deinstalls of
Oracle 9i client on Windows xp. The installs/deinstalls always launch
themselves as a background task. I want to launch the silent install
and wait for the exit code before continuing on. How do I do that??? I

hi ppl,
i'm new to the grp..going thru a major crisis in my professional
life..ve done MCA worked as S\W engr in my 1st job which was mainly of
website development ASP front end and SQL server backend..changed this

I'm planning on installing 9.2.0.6 on a HP-UX/Tru64 server, for testing
and self-leaning purposes. So far I have never installed Oracle on
platforms other than Win32.
I have no direct access to the box, so I'll have to install it from

I am using Oracle 10g on Windows 2003 Server.
I have two questions related to Oracle Text:
1. Memory
What kind of memory does Oracle Text use to index (Shared pool, large

Hi, I was hoping someone could help me. I am trying to display the time part
of a datetime datatype in my query (in this isntance the column containing
the datetime datatype is called 'starttime'). How does one accomplish this?
I want to see the time via a simple select statement ...

i would like some help with exception handling for my backup script.
when i issue the command:
alter system archive log all;
i sometimes get the error:

i am creating a tool using java to profiler plsql stored procedures.
there are two way of installing dbms_packages
1. install profload.sql as sys.
Then creat plsql profiler table(proftab.sql) for each user who want to

Ok,
I know I said my last post was my last post, and the post before that was my
last post, but this; this post is my last post for sure!
Also I know files and permissions to the database should be given sparingly

I am a newbie to this field. I thank u all to read me.
I have a system with a dual boot option (Linux+Windows).
1. I wish to install Oracle through command prompt on LINUX.
2. Is the Oracle DB installation is different for LINUX and Windows. I

I am implementing a SQL script in Orcale that involves a CASE statement
.
The server is Oracle is 8174 and this piece of code runs well in Oracle
9i.

hi ppl,
i'm new to the grp..going thru a major crisis in my professional
life..ve done MCA worked as S\W engr in my 1st job which was mainly of
website development ASP front end and SQL server backend..changed this