All,
Listed below is my code. I get the following errors when trying to execute:
EXCEPTION
*
ERROR at line 57:
ORA-06550: line 57, column 10:
PLS-00103: Encountered the symbol "EXC...
Dear All,
While dropping the user of oracle8i from internal user,
I am getting following message.
SQL> drop user tempuser cascade
2 *
3 ERROR at line 1:
4 ORA-00604: error o...
I need to copy a table identicaly to another. I use this command to do it : CREATE TABLE target AS SELECT * FROM source
But i've got an ORA-00997 error : illegal use of LONG datatype, becau...
I am have troubling figuring out how to convert the code snippet that I have attached.
Is there a similar function to the DATEADD ms sql function and DATEPART functions in Oracle?
Or is ...
Hi,
I have a program here that gets the following error when run from one server, but does not get the error when run on another server.
Anyone has any idea what can cause the below proble...
I am using sqlloader with direct=TRUE , i am trying to insert 2 million records in to table through flat files. This flat files some times may have duplicated records also.
(using Direct Path...
Hi I'm having problems with the listener. When I try to start my database (9i) I get the message that there is no listener.
When I go to the services of Windows, the OracleListener appears to...
Hello all,
Im trying to connect to an Oracle server but im not sure where i have gone wrong and i get the above message when i try to test the connection using the Net8 Assistant.
Following ...
Hello,
Can you explain me the difference between oracle 8i and 9i and 10g also.
Thanks
Hello Everyone,
Please disregard the version i stated earlier it is in fact Oracle 10.2 that i am using
I'd like to thank everyone before hand for any assistance provided. I am trying to ...
Hi all,
I am trying to update a column in a table with data from another table. The SQL I am using is:
update TABLE1 a
set a.col1 = (Select b.COL2 from TABLE2 b
where a.COL3 = b.COL3...
We have a UNIX shell script that calls SQLPLUS but at the moment no way of knowing whether the call failed or not (if DB not available for example). Is getting a return value from SQLPLUS a r...
Hi Gurus,
I have a table WO as:
SQL> Desc WO
actstart date
actfinish date
estdur float
wonum varchar2(10)
....
In a package, I declare:
type actstart_tab_type i...
Oracle 9i.
I get the error said ORA-12154: TNS:could not resolve the connect identifier specified when I try to connect to database through SQLPLUS, but when I connect to it throught TOAD, co...
Hi All,
I have a database in oracle HR i want to know
1.How can i take dump of this database complete.
2.How can i take dump of two tables in it.
3.How can i create another database sa...
All,
I have the below situation
Table : ABC
Owner : JOHN
Another Owner : DAVE
Dave needs to Truncate ABC and Insert rows
what does JOHN grant to DAVE in terms o Ora...
Hi,
i had already posted this prcedure and once again i would like to reopen it
i have a problem and i m getting this exception for this procedure and i donot know how to handle this coul...
I want to change the default value of the columns in OPracle 10g database. I want to be able to set the value to " " and 0 if the dependant on the column datatype. I want to be able to generat...
I'm having to design a database solution where I will track some things shipped and confirmed over various time zone's for USA, Canada and Mexico
It seems like the best solution is to convert...
I'm trying to do direct update on a table, I know I have to have a PK on the lookup table. I do have it.
this works just fine, I have PK on LOOKUP2 table on PRODUCT_CD column
UPDATE ...
I need the to display the Oracle rows in a grid. Using SQL*Plus rows wrap and become unreadable for tables with many columns.
I have used Toad on Windows and its pretty good but now I am work...
Hi,
I'm searching in oracle 9.2i for a string with <>'' but I don't get the exprected result. e.g
Select * from mt_filearchivev WHERE "Value"<>'';
but I get no row, even there is a row with...
I know sqlserver but I am new to oracle
1) I would like to know how to create a simple stored procedure which brings all the values from a table.
2)To alter the first procedure and to accept...
Hi,
I need to retrieve record from the Oracle database by comparing with a time range? The column "OTime" is of Date datatype. I'm using ASP.
This is my SQL:
"SELECT * FROM Purchase WHE...
I have a remote database. I can ping the host but if I use tnsping80 I receive "TNS-12535:TNS:operation timed out"
I know that:
1. TNSPING80 never connects with the network listener.
2. T...
