Error when call dll from oracle
Hi all, please help me!
I have dll write C language, I want call it from oracle procedure but it throws the error: "ORA-28546: connection initiali
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
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
insert Multiple rows into the table from that table data
Hi All,
I have a requirement like to insert mulitple rows into the table from that table data only(I need to replicate the data).
In this ta
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
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
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 to insert random unique values in 2 columns ?
I have table with 2 columns
Create Table code_for_code (
first_code varchar2(10) unique not null,
second_code varchar2(10) unique not null );
present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks
Logging and nologging bulk insert
Hi,
oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
I am trying to use Append during bulk insert?
example:
in
Error when call dll from oracle
Hi all, please help me!
I have dll write C language, I want call it from oracle procedure but it throws the error: "ORA-28546: connection initiali
Help on query replacing the date
Hi Pals,
i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces th
Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the tables with records more than say 100 or so at on
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
present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks
I face problems to extract data from one table and insert it in another one
Hi,
For modifications, I have to extract data from one table and insert it in another one, after this I have to get the new id from the second tabl
! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement to NOT TRUE and skips onto the next 'IF' satement
Can I use a loop
Hi buddies!
Once again with my doubts here.
Right now I am using this sql statement
p_blob(i):= package_email.read_file('shared_files','booki
Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.
When we try to pass an array from VB6.0 to an Oracle PL/SQL Function we are getting the error like
Error is: Argu
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
