BUG in DataGrip; prompt for parameters for declared refcursor

Answered
Avatar
Kloss7
Created

Hello!

There is bug in datagript. It is asking me for parameters when I make in console query like this:

VARIABLE OutputRecordset refcursor;
BEGIN OPEN :OutputRecordset FOR select 1 from dual; END;
/
print :OutputRecordset;

Should I make this query other way to make it work in DataGrip or there is serious bug in software.

Best regards,
Krzysztof Antoń

Votes

0

Share

3 comments
Avatar
Avillasec
Created

I tried adding an exception for ? in Settings->Database->User parameters, but this didn't work.

Always prompt parameter:

declare
    SALIDA             sys_refcursor;
begin
    MY_PACKAGE.MY_SP(
            SALIDA => SALIDA
        );
    ? := SALIDA;
end;

1
Avatar
Yuriy Vinogradov
Created

Hi

This is not a bug, please read about user parameters.

as for now each name started with column is considered as parameter and it can not be changed.

0
Avatar
vasily chernov
Created

Avillasec,

How did you add exception? Could you share a screenshot for User Parameters settings?

0

Please sign in to leave a comment.