BUG in DataGrip; prompt for parameters for declared refcursor

Answered

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ń

0
3 comments

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

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

Avillasec,

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

0

Please sign in to leave a comment.