17/10/2018 11:47
Hi, I`m trying to upload a gif-File to a database (Oracle 10g/jdbc) ...
the interMedia Classes tutorial explains how to do this, so i attendedit`s orders.
My Problem : every time I want to select a row for the image select Front_Tex from surf_geom where id = 31388 for update there is an Exception thrown ORA-01002: FETCH out of sequence.
without the for update part this line is processed but for laterimage upload I have to block access, otherwise there will be anexception.
Can anyb.... read more

1 answersclick here to view

16/10/2018 11:47
Hi, I have oracle 11g database and PHP application on my machine(A). Oneof my PHP orogram need to connect to oracle 9g DB on a machine(B). DoI need to install oracle client on machine(A) and which version do Ineed to install? Thanks much,beta

3 answersclick here to view

15/10/2018 11:47
I contacted Oracle sites in Italy they told me that I need a full license in order to buy CD Packs.
Online store.oracle.com cannot sell to another country.
So, ... there are any books with a Trial edition of Oracle 9i on CD ?Thank you.
======================================================BELLANTONE MAURIZIO - IT Consultant, freelance programmerVia del Progresso 1615047 SPINETTA MARENGO (AL) - ITALYE-mail: bellantone@libero.it======================================================

7 answersclick here to view

14/10/2018 11:47
I have an oracle 10g RAC with sun v880 server running solaris 10.
After having hardware problem on the server and fixing it, now when Ireboot the secondery server, the master server crashes and I have to dohard reboot. Any tought??? I think this is the error for it, 2006-08-29 16:15:47.362: [ CSSCLNT]clssgsGroupGetStatus: CSS shuttingdown.
2006-08-29 16:15:47.368: [ CSSCLNT]clssgsGroupGetStatus: returning 22kgxgnpstat: error: CLSS service is shutting downkjzmpoll: kgxgnpstat err[16 -2147438272].... read more

1 answersclick here to view

13/10/2018 11:47
Hi,I've customised a PHPmyChat instalation According to the instructions but i get an error message : $Is_Error = (isset($Error)); The url is: http://depressionlink.co.uk/chat/phpMyChat.php3 and heres the code: <?php // This is an example of what may be done to include phpMyChat into an // existing web page, regardless of its name.
// You can also include such a file in a frameset.
// Lines below must be at the top of your file because 'index.lib.php3' // sets headers and cooki.... read more

4 answersclick here to view

12/10/2018 11:47
Dear all, How can I use the results in my CASE pieces to help me ORDER?Below a simple just to understand example.
SELECT CASE WHEN column_a > 10 THEN 1 WHEN column_a > 100 THEN 2 END AS helpme_a, CASE WHEN column_b > 10 THEN 50 WHEN column_b > 100 THEN 100 END AS helpme_bFROM exampletableORDER BY (helpme_a * helpme_b) As you can see, I would like to use results from the CASEs in my ORDERBY.
Can this be done? A second qu.... read more

7 answersclick here to view

11/10/2018 11:47
We are in really bad shape because we just realized that the cron job that is suppose to be making a daily backup of our database hasn't been working for a long time. In fact, even when I'm logged in as root and try to run mysqldump from the command line, I get an error: [root@mother backup]# mysqldump -Qu root -pxxxx alb > /data/backup/alb.sql mysqldump: Got error: 1033: Incorrect information in file: './alb/charts.frm' when using LOCK TABLES What does this mean? Where can I.... read more

2 answersclick here to view

10/10/2018 11:47
Hi, I've got a problem with the installation of PHP, make ends with an error 1.
Linux CentOS 3.4 (RH), Apache 2.0.52, PHP 5.0.3, Oracle client 10.1.0.3 andan Oracle 8i database.
I've installed the Oracle client, and it works (set the environmentvariables). I've been able to install and run Apache.
I started with PHP by using './configure --prefix=/usr/local/php--with-oci8=/usr/local/oracle/OraHome_1--with-apxs2=/usr/local/apache2/bin/apxs --enable sigchild' This gives a fe.... read more

6 answersclick here to view

09/10/2018 11:47
Hello folks I need to run multiple instances of MySQL 5.1 server (run as service, database type is InnoDB) on the same windows computer (Windows Server 2008). I have been using this resource: http://dev.mysql.com/doc/refman/5.1/en/mysql-config-wizard-cmdline.html I still have a couple of things I do not understand: 1. Whats the deal with ibdata1 file? Is this all right if it is shared by all the instances? Or shall I point to a separate file for each instance in the corresponding ini file? For e.... read more

6 answersclick here to view

08/10/2018 11:47
Hi, I am trying to generate a flat file with the following layout froman Oracle table: Column Start End Length -------- ------- ----- -------- Column1 1 6 6 Column2 7 10 4 Column3 10 21 11 ....... .. .. ..
....... .. .. ..
I would like to generate this using just SQL. Is SPOOL up to thetask? Thanks in advance.
Nick

3 answersclick here to view

06/10/2018 11:47
HelloI'm trying to create a query that gets the first alphanumericcharacter...
I have cd tracks like this: Good MorningAmerica The LovelyShake your bodyAll or Nothing And I want to show all tracks that star with the letter 'A', the querywould be similar to this: SELECT *FROM trackWHERE track.title LIKE ('A%')ORDER BY track.tile; And the result : All or NothingAmerica The Lovely so far so good... but, i have also have tracks like this: (All) Or Nothing=BFAre you alone?'.... read more

7 answersclick here to view

04/10/2018 11:47
Dear all, I'm trying to create an oracle name servers. but error happen.
the error is : TNS-12560: TNS protocol adapter error.
TNS-00530: protocol adapter error.
32-bit Windows Error: 61: Unknown error.
i'm already reading the Oracle Documentations, but still can't do.
did anyone can resolve this problem.
PS: Listener running OK.
Net Service name running OK.
SQL*Plus login success.
here bellow my configuration : LISTENER.ORA===============# D:ORACLEORA81NETWORKADMINLISTENER.OR.... read more

3 answersclick here to view

03/10/2018 11:47
Hi All, I have a column in my table with values like this: CBMON3.03122005WESAT1.04262006TRSAT3.01282006.
.
.
I want to create a select statement that will allow me to retreiverecords within a range of dates.
Basically the user will enter a date range. I will create the righthalf of the column based on their input (03122005 or 01282006).
However, if I use > or < with a %01282006, it gets everything from thedatabase........
This select does not work: select * from table_1 where subst.... read more

1 answersclick here to view

02/10/2018 11:47
Does anybody know if C++ can be used to interface with Oracle via ASP.NET, etc and Visual Studio? All examples I can find in documentation and online seem to only show VB or C#.
Thanks

1 answersclick here to view

01/10/2018 11:47
Hello,In our application we used dedicated server in Oracle 8.1.7, and thiswas done by adding a comment sign on this line in init.ora# mts_dispatchers = (protocol=TCP) A tuning expert recommended NOT using multi-threaded server was and itworked fine.
Having upgraded to Oracle 9.2.0.4 for Linux there are some performanceproblems. Oracle doc says: In general, it is better to be connected through a dispatcher and usea shared server process. This is illustrated in Figure 5-2, OracleShared Server Pr.... read more

3 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS