I have a file which contains millions of records. A complete records covers 5 lines of the text file. I just want these data into oracle
from each of these 5 lines
1st line character sta...
Hi,
I want to import my database design to a "visual model".
I don't have ERWIN, do you know a freeware or open source that I can use?
I just want to import my model to a "visual model"...
Hi,
i'm using Oracle Forms Builder 6i to connect to mySQL 3.23.49 via
Oracle Open Client Adapter for ODBC 6.0.5.35.0
Now I have a problem of controlling which form to commit if more tha...
I am using Toad Version 7.3.0
I am always getting the error, "ORA-01460: unimplemented or unreasonable conversion requested"
How can I eliminate this and export data from tables.
I am trying to write sql statement to select / insert a distinct value (metername) and other info from a table where pointname is not distinct. metername = pointname
insert into METER(MET...
Dear all ,
as title stated , I am looking for Oracle ODBC driver from microsoft.
please a direct URL to download the driver will be highly appreciated.
thanks,
Hi I having trouble trying to wrap a function I have created. I get the following error when I wrap the function on the dos prompt:
$ wrap iname=decrypt_string.sql oname=decrypt_string_wrap...
Hi,
I am running solaris 9, Oracle 9i and Veritas Netbackup 4.5 at the moment. Over the weekend, we had some network issues and one of our netbackup servers was disconnected from the netwo...
I have a stored procedure which returns a PL/SQL table of records.
I need to understand how I can access this table return using Perl DBI/DBD and Oracle 8.1.7.
I use the following statemen...
I have a csv file where one of the fields contains the new line character, when I load the file using the sql loader it gives me the error.
Here is the data file
4/24/2000,Chemical Enginee...
The package body should be able to be seen when you click on the "+" next to the package on procs tab of TOAD. But I can not see the package body for any packages with my ID on my PC, only spe...
Silly question but since I can't read the font I have to ask! Can anyone tell me how to change the font used for Comments in TOAD (v 7.6)?
I am trying to test a stored procedure which is used by a Crystal Report in Toad to make sure I can get data outside of Crystal. When I try to execute my code, Toad wants me to initialize the ...
Hi
I'm trying to write a report that has an outer join to a constant. I have the following SQL:
SELECT .......
FROM ........
WHERE ext_trad_ref.cmpy_num(+) = trade.cmpy_num
...
I have lately used net manage ($ORACLE_HOME/bin/netmgr) to
set the listener password to abcd.
Now if I try to stop the listener at the command prompt, this is what happens:
$cd $ORACLE_H...
Silly Question but I cannot figure this out.
I have TOAD v7.3.0.0 and in the schema browser when I select the tables tab the tables are not sorted alphabetically. How can I get the tables s...
Hello,
Could someone could help me to find a best solution in such situation?
I am not satisfied with form's working while deleting record...
One way is to create a push_button and to w...
Im using Access 2003 and I wanted to know if there is any way that I can create a view like in sql that will show a diagram of the tables and the keys. The will be of linked tables. Any 3rd ...
i am using toad to develop pl/sql
there is a way to check values in ys_refcursor during debug??
Hi,
First I got the ORA-01578 data block corrupted on file #3, block #4159 error message. Then, I found out that corruption is on the rollback segment RB3. I took the RB3 offline. I trie...
Mabe coul someone help me to get arround such an error??
PDE-PXC002 Program unit execution aborted due to unhandled exception (100501)
Solveiga
While I was developing a form by devloper 6i,
after adding elements to lis item the form builder hangs,
when I try to reopen the form again I got the error message frm-10043 can't open form,...
We want to run ASP page to display some records w/ picture (BLOB) from Oracle 10g database. And just found some sample coding, that is worked for picuter display. But when I change it somethin...
I have 3 different ref cursors which stores data for 3 different years. The ref cursors have 4 columns of
Dept,Manager,Emp Name ,Salary(of each year).
I need to form a 2 dimensional array...
The stored proc for the most part seems to work however when it get a certain p_emp value I get then error 6502 ORA-06502: PL/SQL: numeric or value error. The p_emp does exist so there are no ...
