Helpforce provides free 24/7 online technical support

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

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

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======================================================

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

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

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

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

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

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

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

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

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

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

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

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

eDiscover

Click the logo to go back to the main page

Databases

Search eDiscover

Categories