I am trying ot use table functions for the first time so i'm not too
sure if i'm doing this all wrong anyway.
I have created a ref cursor in a package. Then i have a script to
create a function that will use that cursor as an IN parameter (to

sys.dbms_aqadm_syscalls is oracle wrapper. Its procedure and fuction
prototype is not available. How to use sys.dbms_aqadm_syscalls ?
Thanks
Swapnil.

I want to know how exactly 'select sysdate from dual' works. From where
Oracle brings in sysdate if the init parameter fixed_date do not have
any value set against it. I know it brings the server machine date time
and if it does then exactly how is sysdate pointed to bring in server

I am trying to configure an snmp agent that queries oracle instances
for performance data.
in this agent i must specify oratab and ORACLE_HOME
no probs with ORACLE_HOME it is

I'm working on the porting of a old Informix ESQL application to Oracle
Pro*C.
After some struggle against different issues, I'm stuck at rfmtdate
function.

ODTUG Kaleidoscope
Kaleidoscope is the annual conference of ODTUG, the Oracle Development
Tools User Group presenting a variety of critical content and sessions
for Oracle Developers on a range of topics including: Business

Can anyone help me.. Has anyone does this before.
I want to run Oracle on Linux. Can I run the standard Linux Oracle
install on SUSE 10 standard. Do I need SUSE 10 Enterprise Server?
BTW I will be installing on a virtual machines running VMWare.

My sqlplus seems to be unable to perform open for command! Anybody have
an idea as why is this?

Oracle server 8.1.7.4.0
I'm dealing with an application over which I have no real control to be
able to change table structure other than to add my own columns.  I am
trying to create a union query of the sort:

Oracle enterprise ed. 9.2.0.5 on AIX 5.3
Getting on ORA 1114 error writing to file. The message goes on to quote
the file number : 530 and the block number. However, I cannot find file
530 in the database. Either as a file_id or relative_fno in

I have a sql to retrieve records from the database, and I spool the
output into a file at the beginning of the sql. The spooling works fine
when I manually run the sql in Sql*plus.
I am thinking to schedule this sql as a daily job using DBMS_JOBS

I had been campus recruited by IBM Global Services and after only one
month training I am working as a DB2 DBA on client side for past two
months.
I dont see many oppurtunities building for me in future since a DBA

What does the group think about this column? Anything to it?
http://www.eweek.com/article2/0,1895,1913887,00.asp

I'm trying to insert a record into a table, but getting the error -
'ORA-01400: cannot insert NULL into (....'. The table structure is:
recnum number primary key,
ap# varchar2,

hi i am writing a new stored procedure. the  error i am gettin g is i
have a variable whereclause
in this i have an and clause as
whereclause :=  ' AND usr.act_key IN (SELECT DISTINCT act2.act_key