Recent content by Frank Schmitt

Using the "Copy as command" feature of the "export tables" dialog, I can create an export script that can be run from the command window, and I can put together multiple export commands to run them sequentially: Export Tables=PLSQLDEV_EXPORT_DEMO1 Method="PL/SQL Developer" Compress...

When using the "Export tables" functionality, I can set a WHERE clause to limit the data to export: value like 'x%' However, this is ignored in the "copy as command" feature. The generated script looks like this: Export Tables=PLSQLDEV_EXPORT_DEMO1 Method="PL/SQL Developer" Compress...

Scenario: I have a view with column names contain spaces: create view v_plsqldev_bug(id, "name containing spaces") as select 1, 'hello' from dual; Right-clicking this view in the Object browser and choosing "Edit" generates this (invalid) SQL Statement: create or replace view...

It's reproducible; here's the DDL statement for the table on the source instance (I've omitted the schema name and storage clauses): CREATE TABLE PROFILE ( PROFILE_PK NUMBER, PROFILE_NAME VARCHAR2(255) NOT NULL ENABLE, PROFILE_DESCRIPTION VARCHAR2(4000), CREATED_BY VARCHAR2(30)...

This one's been bugging me for a while - sometimes (not always - it seems to depend on the table), "Compare Table Data" generates an empty script although it mentions that it found differences. This bug was introduced in V11 and still persists in V12 (I haven't checked the V13 beta). Here's the...

Hi, I just detected a IMHO serious bug in PL/SQL-Developer (Version 7.1.1.1350). Reproduce create a new package delete everything but the comments from the package header created by PL/SQL Developer template push the sort button This will delete all comments in the package header :eek...

PL/SQL Developer Version 7.1.1.1350 Kind regards Frank

This happens if you use EZNames for your database connection (e.g examplehost:1521/exampledb) - see my post from 2007-07-10. Kind regards Frank

Hi! PL/SQL Developer doesn't handle EZNames correctly when comparing user objects between databases, resulting in I/O error 123. Reproduce Tools -> compare user objects Enter a Oracle EZName for the target connection, e. examplehost123:1521/exampledb, and connect Start the comparison Select...

Either declare the procedure as AUTHID DEFINER like Devil proposed, or grant the system privilege "CREATE USER" to the user that calls the procedure. BTW, you might want to reconsider your naming conventions - procedure names like "cr8user" are *SO* much harder to read than "createUser", and...

Marco, Thanks for the quick response. Is this list of enhancement requests public? Do you have any information available if or when this feature will be implemented? Thanks for your time & kind regards

Hi! I've found a possible bug concerning the "compare user objects" utility inside PL/SQL developer; consider the following scenario: create tables in schema user1 create table t1 (id number not null primary key); create table t2 (id number not null primary key, t1_id integer); compare...

Scenario two developers start editing the same package - developer1 commits his changes + quits, afterwards developer2 commits his changes Result the changes of developer2 are lost Request Could PL/SQL Developer check for modifications on the DB object before commiting and issue a warning/error...

You're correct - executing the query in SQL/Plus gives the same error. I suspected DOA because the Query worked fine in Hora (our standard SQL Tool) - obviously Hora handles bind variables differently. Using substitution variables works fine with DOA - but for the time being, we'll recommend our...

Ok, since the trace file is about 2MB, I'm sending it to you by e-mail.