Completion Insight in 4.0

Mick265 Jul 19, 2013 1:02 PM

Hi,

I ask about that some time ago.

From version 2.1 Completion Insight won't work with packages/functions.

In my company database there are configured functions that I can type/ask like normal tables in format:

select * from table(schema_name/package.function_name) - function_name should be listed.

In version 1.5 everything was fine but in next version something was wrong.

I see that in V 4.0 issue still exists.

I wonder i that this issue could be caused by version of Java or JDBC driver, but the trial with couple of java versions and drivers have not been successful.

Thanks for any advice.

Michal

1. Re: Completion Insight in 4.0

thatJeffSmith-Oracle Jul 19, 2013 1:48 PM (in response to Mick265)

Does this work?

begin
sys.dbms_output.

And then invoke the insight feature, either wait if you have the automatic bit enabled, or use ctrl+enter to force it. If that doesn't work, then we have an issue at the core feature. If that does work, then we can look at your use case.
Like Show 0 Likes(0)

Actions
2. Re: Completion Insight in 4.0

Vadim Tropashko-Oracle Jul 19, 2013 4:57 PM (in response to Mick265)

Bugged as 17191521:

select * from table(dbms_output. );
--------------------------------^ctrl-space works, while select * from table(sys.dbms_output. );
-------------------------------------^ctrl-space doesn't
Like Show 0 Likes(0)

Actions

Go to original post