I am using SQL Developer 1.0.0.15 and Oracle 10g
The following came:
If one is creating a function in the following manner:
CREATE OR REPLACE FUNCTION "SomeTestFunc" ( val NUMBER ) RETURN TYPES.ref_cursor AS result TYPES.ref_cursor; BEGIN .... RETURN result; END
Oracle will name the function exactly like it is written in the declaration.
Any client application is required to offer the function in case sensitive way.
However, there is another way of declaring a function:
CREATE OR REPLACE FUNCTION SomeTestFunc ( val NUMBER ) RETURN TYPES.ref_cursor AS result TYPES.ref_cursor; BEGIN .... RETURN result; END
Note, there are no quotation marks in the function name.
In this case, the function name is case insensitive in Oracle SQL developer.
For client application all variants like someTESTfunc or SEMEtestFUNC will be resolved to the correct function.
I beleive this can be tuned somewhere in the deep.