should this be raised as a BUG? - problem with case sensitivity when trying to run stored procs [message #515427] |
Thu, 18 February 2010 18:15 |
Thomas.K.Hill Messages: 13 Registered: February 2010 |
Junior Member |
|
|
Hi,
navigating to a stored procedure called APPL.SP_test, right clicking on the entry and selecting 'run' from the context menu brings up the configuration parameter page allowing me to enter parameter values (so far so good), but when clicking on 'OK' to finally execute the procedure I am receiving an error that APPL.SP_TEST is not recognised as a function or procedure.
Is it not possible to use lower case in procedure name?
Can I somehow configure DTP so that when building the call the procedure name is surrounded by " (CALL APPL."SP_test" instead of CALL APPL.SP_TEST).
Thanks
[Updated on: Thu, 11 March 2010 07:15] Report message to a moderator
|
|
|
|
|
Re: problem with case sensitivity when trying to run stored procs [message #519437 is a reply to message #519424] |
Mon, 08 March 2010 19:47 |
Thomas.K.Hill Messages: 13 Registered: February 2010 |
Junior Member |
|
|
Hi,
I am using Apache Derby 10.5.3.0. I know this database (or it's JDBC driver) by default is case sensitive. Shouldn't DTP to properly handle such drivers/databases always include object names in double quotes to be on the safe side? as this would work for (people defining) database objects with capital letters only AND also for those making use of case sensitivity?
The DTP Database Explorer shows my sample object "SP_Test" in schema APPL as SP_Test (without quotes).
When using the generate DDL context menu a DDL statement
CREATE PROCEDURE SP_Test
is generated - whereas imho the statement should be
CREATE PROCEDURE APPL."SP_Test" .
Same when trying to run the procedure. The 'Configure Parameter' page comes up fine, but when trying to execute the statement the command string
CALL APPL.SP_Test is generated in the background and submittted. This time the schema name is included in the generated statement, but still the procedure name is not surrounded by double quotes which is why the error
APPL.SP_TEST is not recognised as a function or procedure
is thrown (Note the procedure name in all capital letters).
This is why I was asking whether there might be an option which can be set when configuring DTP that case sensitivity is required / to include double quotes in generated DDL/DML statements.
Thanks
Thomas
[Updated on: Tue, 09 March 2010 06:51] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.03219 seconds