Recent content by Clever Idea Consulting

I would like to second this request. I posted on Stack Overflow this issue as well.

DoDo, If you: * use 10gR2 client * grant execute on *both* types you will not have the problem you report. SQL*Plus: Release 10.2.0.3.0 - Production on Mon Apr 2 11:01:45 2007 Connected to: Personal Oracle Database 10g Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data...

I'm not sure what DoDo means by his last posting, so let me clarify: I don't have a machine with 8i or 9i client. However, I can verify that DoDo's behavior (in his first post) is completely reproducible via 10gR2 client libraries as well. So for 10gR2, it's not a library issue. It's a...

Scott's request is a great one, I completely second him on the value of such a feature in a future release.

Your company's standard of wholesale public synonyming and grants is a little scary - but here's a cool tip, use: CREATE OR REPLACE PUBLIC SYNONYM syn FOR obj; It let's bypass at least on error the first time you are executing your boilerplate.

DATE datatype has no timezone quality whatsoever. It is up to the application to put in the right values. If the application has relegated that preogative to something like a default SYSDATE quality on a column, then it will use the SYSDATE of the database server - not the application server -...

This is not a bug of any kind in either PLD or the Oracle dll. In addition to granting privileges to the table, one must also grant execute privileges on both types.

Works as expected for me. Might be a RDBMS version issue. I am using 10.2

Thanks Marco.

What is the current plan on implementing normal functionality when working with double quoted identifiers? Most (all?) features of the IDE do not work with properly with such identifiers (i.e., create procedure "MyProcedure"....) I REALLY thought the 7.1 version was going to have some improved...

That would be great! Thank you so much.

Good idea Claus. I checked it out and it had no effect. No matter the Editor setting, it comes back all lower case inside the double quotes. It's definitely not a beatifier thing, either, as it does (and always should) ignore text literals in both single and double quotes. So, can this be...

I am using the latest 7.0.1.1066 build / 10gR2 server(win32) / 9iR2 client bins The code completion returns the double quotes, but it is always in all lower case between the quotes. For example: PackageA spec has defined: "MyConstant" constant varchar2(10) := 'whatever'; When typing code...

Using 7.0.0.1050 Command Window This is not a big problem, but it is inconsitent with SQL*Plus (9iR2 and 10gR2) and I abhor having to fire it up while I'm writing code. In a script, if a line begins with "REM--" immediately prior to any SQL command, that command fails with the ORA-00900. For...