Problemns with 7.1.1.1339

[Wellingthon Ara]

Hi,
I have 2 versions of PSD instaled...
I have the licence of the 7.0.3 and I use it for produce, but a client has a 7.1.1 licence, so I install the 7.1.1 trial version...

He say about 4 problemns, and I can see 3 of then...

1) When I have a clob field, and edit in text mode and terminate the string with ... this is not returned in a consult in sqlEdit window.
In fact, in the 7.0.3 version it's run ok... in the 7.1.1 it not run... bug or configuration?

2) when I select a text in the command window, the color of selected text change to white... in my client its not do... and the selected text black and the dark blue become dificult to read... there are some configuration for that colors?

3) He has a trigger to capture errors in the db...
he say subconsults are creating log records... of "invalid table" type...
this is a vacant question... and I don't know what I can do to resolve...
the sub-selects executed in the sqlplus not generate this log type...

the 4th error is about copy/past functions related in some topics...

What do to solve these problem?

 

[Marco Kalter]

1) When I have a clob field, and edit in text mode and terminate the string with ... this is not returned in a consult in sqlEdit window.

I'm not sure I understand the problem. Can you elaborate?

2) when I select a text in the command window, the color of selected text change to white... in my client its not do... and the selected text black and the dark blue become dificult to read... there are some configuration for that colors?

If you go to Tools > Preferences you can set the editor colors on the "Editor" page, and the font colors and background colors on the "Fonts" page.

3) He has a trigger to capture errors in the db...
he say subconsults are creating log records... of "invalid table" type...

Can you let me know the complete error text?

 

[Wellingthon Ara]

question 1)

in 7.03 version
1) I create a Table (i integer, c clob);
2) I "select * from from update";
3) I insert a row, and, in "i" field I write some number... and in the "c" field I write a text... on the text final I write ... to finish with a chr(13) with nothing after then.
4) commit

and, when I reopen this "select"... the "c" field is with this chr(13) in the end of text...

In the 7.1 version...
1) I reopen the record inserted with 7.03 version and the chr(13) is not there...
2) I create a Table (i integer, c clob);
3) I "select * from from update";
4) I insert a row, and, in "i" field I write some number... and in the "c" field I write a text... on the text final I write ... to finish with a chr(13) with nothing after then.
5) commit

and the record inserted with 7.1 is not with the chr(13) in end of line... it's missing the chr(13)

question 2)
In the tools -> preferences -> editor options section I can change the colors of text, comments and keywords... but,,, I can't change de color of a "selected text" in any editor...
Well, this problem I don't see in my plsql trial 7.1 trial edition, but, in my client using this version... the selected text is like in the picture in link

so,,, I trust in my client...

Question 3)
My client generate this test:

-- Create table
create table LOG_ERROS (ERRO VARCHAR2(4000), SQL VARCHAR2(4000));

CREATE OR REPLACE TRIGGER TESTE_LOG_ERRORS AFTER SERVERERROR ON DATABASE
declare
v_error VARCHAR2(1000);
v_sql_text ora_name_list_t;
v_sql CLOB;
BEGIN
for i in 1 .. NVL(ora_sql_txt (v_sql_text),0)
loop
v_sql := v_sql || v_sql_text (i);
end loop;

v_error := DBMS_UTILITY.FORMAT_ERROR_STACK;

insert into log_erros(erro,sql) values(v_error,v_sql);
END;
/

and when a "subselect" consult like "SELECT * FROM (SELECT * FROM DUAL);" is running on sqlEditor generate a "ORA-00903: invalid table name" error...
when this consult run on a command window... this code don't result a log error...
"SELECT * FROM LOG_ERROS;"
but, in all cases,,, the sql result is returned fine...

a consideration...
in a consult in the "log_erros" created tables, I see the sqlEdit generate the sql field value as "select * from select * from dual", and the command window, with a forced error has the sql field value as "select * from (select * from dual)"

tks

 

[Wellingthon Ara]

Nothing about?

 

[Marco Kalter]

question 1)

and the record inserted with 7.1 is not with the chr(13) in end of line... it's missing the chr(13)

Okay, I see. We'll try to fix it.

In the tools -> preferences -> editor options section I can change the colors of text, comments and keywords... but,,, I can't change de color of a "selected text" in any editor...

The selection color can only be changed in the Windows Appearance settings.

when a "subselect" consult like "SELECT * FROM (SELECT * FROM DUAL);" is running on sqlEditor generate a "ORA-00903: invalid table name" error

This query runs fine for me. Can you reproduce this?

 

[Wellingthon Ara]

This query runs fine for me. Can you reproduce this?

This is a consideration of the 3th problem...
when I use a subselect in the sqlwindow the oracle report a database error, and the error cause is "invalid table", with the sql error reported is my consult without "(" and ")" chars...

My client generate the code

-- Create table
create table LOG_ERROS (ERRO VARCHAR2(4000), SQL VARCHAR2(4000));

CREATE OR REPLACE TRIGGER TESTE_LOG_ERRORS AFTER SERVERERROR ON DATABASE
declare
v_error VARCHAR2(1000);
v_sql_text ora_name_list_t;
v_sql CLOB;
BEGIN
for i in 1 .. NVL(ora_sql_txt (v_sql_text),0)
loop
v_sql := v_sql || v_sql_text (i);
end loop;

v_error := DBMS_UTILITY.FORMAT_ERROR_STACK;

insert into log_erros(erro,sql) values(v_error,v_sql);
END;
/

to capture servererros...
When I consult like "select * from (select * from dual)" in a command window any log is generated...
when I consult like "select * from (select * from dual)" in a sqleditor window a log with "invalid table"' type is generated, but, in my sqlwindow the resultset is showed normaly...
consulting the log_erros table, I can see the consideration related top...

In the two cases the query run fine...
but, in sqledit window a server error are reported, captured by that trigger...

Thanks...

 

[Wellingthon Ara]

something about?

 

[Marco Kalter]

Not yet.

 

[Wellingthon Ara]

And now?
Something about?

 

[Marco Kalter]

No, I cannot reproduce the error.