Unquoted identifiers must begin with an alphabetic character (see rule 6 here). You’re trying to assign a value to a column with a name starting with a number 1AO00, 1AP00 etc. Without seeing the table definition for CustomersPriceGroups we don’t know if it has columns with those names. If it does then they must have been created as quoted identifiers. If … Read more
I am answering this for the benefit of future community users. There were multiple issues. If you encounter this problem, I suggest you look for the following: Make sure your tnsnames.ora is complete and has the databases you wish to connect to Make sure you can tnsping the server you wish to connect to On … Read more
I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error:
Your path of directory Tnsnames is incorrect, check it in Tools\Preferences\Data Base\Avanced:
This is called a correlated update Assuming the join results in a key-preserved view, you could also
Based on the comments left above I ran this under sqlplus instead of SQL Developer and the UPDATE statement ran perfectly, leaving me to believe this is an issue in SQL Developer particularly as there was no ORA error number being returned. Thank you for leading me in the right direction.
Ok, well, since you didn’t show any code, I’ll make a few assumptions here. Based on the ORA-1461 error, it seems that you’ve specified a LONG datatype in a select statement? And you’re trying to bind it to an output variable? Is that right? The error is pretty straight forward. You can only bind a … Read more
I have fixed the problem, just need to check: and then check: and then use:
Try replacing the string literal for date ‘1989-12-09’ with TO_DATE(‘1989-12-09′,’YYYY-MM-DD’)
Just add a new datafile for the existing tablespace To find out the location and size of your data files: