retrieving policy name inside the function called by this particular policy
Hi there,
I've playing around with dbms_rls package, trying to set up some security repository, linking users to what
columns and row values they
How can I Compare two xml documents?
Hi all,
I am doing a POC for my project and I am using XE database 10g version.
I want to make a comparison between two xml document stored in a
Getting number of affected rows in SQLPLUS..
Hi everyone,
I have a shell script where i am invoking sqlplus, running a query and saving the result in a spool file in a .csv format. Now this f
Oracle Connectivity
Hi Every One,
Can we access SAP from oracle database.If it possible then please specify the list of steps(i.e connectivity) to access SAP from
Pass sql into pl/sql and create RMAN duplicate script.
Hi,
I'm new to pl/sql and I'm trying to write a script that will generate some RMAN commands to do a database clone.
I want to able to run the s
AUTONUMBER PROBLEM
Hello Everyone,
My name is Jones and i am new to this forum and to oracle. I am using oracle 9i. the below mentioned is my problem.
SQL> CREA
How to form a xml form table with a single sql statement..?
Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't find one exactly like this. Let me explain the problem
Supress some serveroutput but not all
Hi,
I have a script I'm working on that uses plsql to create and RMAN script, this uses dbms_output and also accepts user input as variables.
Th
DBCA Templates
Hi all,I'm working on creating a template for DBCA, but can't find any documentation on the parameters that one can use within the template. Obviousl
media recovery
Hi, i startup the database i got the errorSQL> startupORACLE instance started.Total System Global Area 146800640 bytesFixed Size
Export hangs
Hi all, please helpI have a Oracle 10.2.0.3.0 database. When I want to query the dba_segments or dba_directories views Oracle just hangs, and when I
Not connecting to DB using ruby, error:env.c:257:in oci8lib.so: ORA-12154:
Hi All,I am trying to connect to the database server from the client server using ruby and facing the following issue-$ruby -r oci8 -e "OCI8.new('temp
ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
Hi all,Oracle 10g. Linux.I'm facing the below error while trying to import a dumpfileIMP-00003: ORACLE error 604 encounteredORA-00604: error occurred
C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.What libraries can I link into my project to make this work?I r
Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g
I am investigating how to run a Java stored procedure in multithread mode.I know that if I change the program to be multithreaded, the Database runs i
data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in the functional spec are numbers.
In the column definition
Consuming third party Payment Gateway API from Procedure.
Hi All,
First of all i would like to thank all the people of the oracle forum for providing very good solutions.
Here is my query.
We are imp
Revoking alter any table from a schema
Hi All,
i am working in Oracle 10g.
my requirement is to revoke all kind of DDL operations(except creating procedure etc) from a schema or user. f
Cursor statement failed with errors
Following statement failed with the errors.
cursor proj_cursor1 is (select projectID from dsqa.table1 where projectID = any(select projectID from d
Need help with basic sql
Hi,
I am using oracle 10g, and having some small doubts related to sql , here goes the situation
I have a Transaction table , which contains rec
