Home » SQL & PL/SQL » SQL & PL/SQL » Curious Behavior on Old Oracle 10g Server
Curious Behavior on Old Oracle 10g Server [message #293345] Fri, 11 January 2008 13:45 Go to next message
jayz240z
Messages: 11
Registered: August 2007
Junior Member
We recently migrated our 10g database to a new 64 bit windows machine. When we ran our product against the new db, we found some curious results. Somehow, we managed to update the Java on the old server to include functions from our coldfusion server. What I mean by that is we were able to run the following query against the oracle db and it would work:

select Ucase(user_name), val(user_id)
from users


Ucase is a coldfusion function so is val. Of course neither should work against a oracle database. How do you suppose we were able to do this? My theory is that we managed to update the Java on the oracle database, with the Java library from our coldfusion webserver (its Java based).

Jason
Re: Curious Behavior on Old Oracle 10g Server [message #293350 is a reply to message #293345] Fri, 11 January 2008 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

How do you suppose we were able to do this?

Update your code to use Oracle native functions.

Regards
Michel

[Updated on: Fri, 11 January 2008 13:59]

Report message to a moderator

Re: Curious Behavior on Old Oracle 10g Server [message #293443 is a reply to message #293345] Sat, 12 January 2008 19:20 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
does not work on my 11g database (not that I expected it to). Not one of any of the pieces is valid.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select Ucase(user_name), val(user_id)
  2  from users
  3  /
from users
     *
ERROR at line 2:
ORA-00942: table or view does not exist


SQL> l
  1  select Ucase(user_name), val(user_id)
  2* from user_users
SQL> /
select Ucase(user_name), val(user_id)
                         *
ERROR at line 1:
ORA-00904: "VAL": invalid identifier


SQL> select Ucase(dummy) from dual;
select Ucase(dummy) from dual
       *
ERROR at line 1:
ORA-00904: "UCASE": invalid identifier


You must be running your code through some piece of software (jdbc driver maybe) that is translating for you.

Good luck, Kevin
Previous Topic: Update using sequence
Next Topic: Bulk Collect Tuning
Goto Forum:
  


Current Time: Sat Dec 10 18:46:52 CST 2016

Total time taken to generate the page: 0.28402 seconds