Database
Hi,
During execution of my procedure, I have faced this error (Value exceeds limit of SMALLINT precision). I could not trace down the error to the exact location. Also the compiler does not tell me the line number or anything that helps me trace the error.
Can anyone help me locate the problem to solve this error? Thanks.
- 5726 views
- 1 answers
- 21 votes
Hi everybody,
I wish anyone can help me! I want to export information into a spread sheet so I try to establish Connection between Oracle PL/SQL programs and excel, and then I get the error ORA-106556. I have been searching on the web for some topics or solutions related to this error, but I don’t find any solutions.
Thanks in advance for your help, and by the way, the connection’s been set via DDE Initiate.
Able31.
- 7126 views
- 1 answers
- 0 votes
Hi,
I'm a bit confused with TNSNAMES.ORA file. When I was connecting my database from my client location(UK) with service name "utv015"(as it is in tnsnames.ora), it was working fine. But when I try to connect to the same database with same service name and setting from India, it is not connecting even within the same client network. However If I change the tnsnames.ora file to reflect the service name to "utv015, utv015.seml.xyz.net = ( blaa..bla…)" (only the service name not other information) and connect the database with service name "utv015.seml.xyz.net", it is responding. I am just wondering what is happening here as this name is simply an alias.
What is the impact of this service name?
- 1201 views
- 1 answers
- 0 votes
I have searched the internet and can't tell if the users query fails when I see the message in the alert log. The query is coming from a user running a report in business objects. What user and what query/report I can't tell. I have been going through the audit logs in Business Objects, and I am not finding report failures corresponding to the timestamp in the alert .log which makes me think maybe the query completes even though I receive the error message.
Please tell me the reasons for this error.
Thanks.
- 2169 views
- 1 answers
- 0 votes
Hi,
A few days before, tablespaces were dropped by users in Oracle databases. I have backup for these tablespaces. I need to restore these tablespaces in Oracle databases.But during the restore I was getting ora-01203: wrong incarnation of this file – wrong creation SCN error file.I have explained below what i did.
- 3447 views
- 1 answers
- 0 votes
Hello Experts,
I downloaded Oracle Developer suite 10g and installed in my PC. Then I opened a form and created one module of emp table. After that I started OC4J instance in Edit/Preference/runtime set application server url http://shahzaib-1:8889/forms90/f90servlet
(Reset to Default) then after that I ran the form through web and download Jinit (JInitiator 1.3.1.17). It then gave me an error
ora-12560 TNS Protocol Adapter Failure
I pressed OK and connected again but again same error. Please help me. I am using oracle 10g database and developer suit 10g only in server no client setup yet.
Thanks in advance.
- 2121 views
- 1 answers
- 0 votes
Hello,
I have a very strange error. We have a database with multiple schemas, now in one schema a new error occurs. This is the situation:
I have a view, with a call to package 'A' which calls package 'B'.When I do a select on the view in SQL/Plus , I get error
ora-06508: PL/SQL: could not find program unit being called
Here all the units are valid. If I recompile the units which are called, the problem disappears but after a few hours it re-appears. We try to increase server shared memory also but that didn't help. Can any one suggest the solution for this?
Regards,
Cyan.
- 3137 views
- 1 answers
- 1 votes
Hello there,
I installed oracle in my laptop running on windows vista ultimate. Honestly, I am new in using Oracle Database and I really want to learn more about it. At first I never had a problem using this software, until an error dialog box pops up on my screen when trying to save my file.
Error saving
“C:oracleproduct10.2.0db_1networkADMINtnsnames.ora”!
Probably the file is locked by another application.
- 1185 views
- 2 answers
- 0 votes
Hey techyv experts,
I am new to SQL and trying to learn everything about it. When I was trying to generate SQL Statements using the SQL Builder and selected two join columns, I encountered this error message:
Incompatible Types
IWAQ0004W Join types not compatible
The type of column DEPTNO is CHAR
The type of column SALARY is DECIMAL
- 1515 views
- 2 answers
- 0 votes
Hi,
I tried to install Oracle Database 11g on my pc running on Windows Vista Home Premium 64 bit. When I tried to run the program, an error message appeared on my screen.
Here is the exact error message:
Windows Could not start the OracleDBConsoleorcl on Local Computer.
For more information, review the system Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specificerror code 2.
- 1412 views
- 2 answers
- 0 votes
Latest Articles
Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies
Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...
Top 10 Technology Trends For 2025
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
10 Facts About The Dark Web
Top 10 Latest Steam Cleaner Machines
Latest Tips
Top 10 Internet Monitoring Software
Top 10 Best Partition Manager Software
