Print Thread
about a code assistant behavior with pl/sql types
#57388 12/22/17 02:37 PM
Joined: Jun 2003
Posts: 71
Russia
A
Albert Offline OP
Member
OP Offline
Member
A
Joined: Jun 2003
Posts: 71
Russia
Hello!
For example we have such pl/sql block:
SQL Query
declare 
  type t_index_info is record(
    owner           all_indexes.owner%type,
    name            all_indexes.index_name%type,
    tablespace_name all_indexes.tablespace_name%type,
    degree          all_indexes.degree%type,
    ini_trans       all_indexes.ini_trans%type);
  v t_index_info;  
begin
  v.
end;
When we type a dot after a variable "v" PLSQL developer emits huge number of sql:
https://pastebin.com/Y1YHp96v
Thnak you


There are 10 types of people: those who know binary and those who don't
Re: about a code assistant behavior with pl/sql types
Albert #57389 12/23/17 09:27 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
The Code Assistant needs to determine if the field types are object types.


Marco Kalter
Allround Automations
Re: about a code assistant behavior with pl/sql types
Marco Kalter #57390 12/23/17 07:46 PM
Joined: Jun 2003
Posts: 71
Russia
A
Albert Offline OP
Member
OP Offline
Member
A
Joined: Jun 2003
Posts: 71
Russia
Thank you! But i think that you can do it in more short way.
At present time PLD hangs up on several tens of seconds


There are 10 types of people: those who know binary and those who don't

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 15 (0.010s) Memory: 2.5014 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-10 15:57:31 UTC
Valid HTML 5 and Valid CSS