code assistant improvement

[bobL]

Hi,

In Editor :

you write : "
Code Assistant improvements in version 6.0.1.848
The Code Assistant now supports user defined record type variables, cursor variables, all rowtype and subtype variables, and select statements with inline views:"

but, for example, if I declare a new type :

TYPE t_occEmp IS TABLE OF emp%ROWTYPE;

--#### instanciation of type
occEmp t_occEmp;

when I wrap

occEmp(1).

There is no code Assistant.

One future enhancement ?

Thanks for helping & looking

Regards,

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Ivan C.]

Marco,

Code Assistant also goofs at displaying the content of a packaged cursor (a cursor declared in a package's specification). To reproduce it use the following command:

CREATE OR REPLACE
PACKAGE pkg_cursor_bug AS
   -- Constants
   SOME_CONSTANT CONSTANT VARCHAR2 (1) := 'A';
   --
   -- Public Cursors
   CURSOR c IS
      SELECT empno, ename
        FROM emp;
END pkg_cursor_bug;
/

Now, open a SQL Window, and type the following:

BEGIN
   FOR a IN pkg_cursor_bug.

...at this point Code Assistant will bring a list of ! package's content ! instead of cursor's content.

I know you'll add it to the list of bug fixes, so thank you in advance

 

[Marco Kalter]

That seems correct to me. Or am I missing something?

 

[Ivan C.]

Sorry, the content of the SQL Window should be:

BEGIN
   FOR a IN pkg_cursor_bug.c
   LOOP
      IF a.

... now I would expect a list of cursor's columns, but I get a list of package's "members".

Again, I'm sorry for the confusion, and, thank you.

 

[Marco Kalter]

This is indeed not correct. We'll fix it.