0

I'm using datagrip with oracle 11g.

VARIABLE TEST_VALUE NUMBER
BEGIN
    :TEST_VALUE := 100;
end;
PRINT TEST_VALUE;

then pop up enter parameters and execute window.

how to use binding variable in datagrip??

working in sql*plus

Community
  • 1
  • 1
HelloRacoon
  • 87
  • 1
  • 9
  • Can you please explain what you want? You son't want this parameter window to apear? – moscas Aug 06 '19 at 09:12
  • this code don't need enter parameter window. variable is initialized in procedure block. so result will just print 100 as test_value. if i execute this code in sql*plus, it works. – HelloRacoon Aug 07 '19 at 00:38
  • and this code is reference example by oracle. https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve031.htm#SQPUG051 – HelloRacoon Aug 07 '19 at 00:43
  • 1
    `variable` and `print` is neither valid SQL, nor valid PL/SQL. It is specific to SQL\*Plus –  Aug 07 '19 at 10:51

1 Answers1

1

This is SQL Plus dialect. Unfortunately, DataGrip doesn't support running SQL Plus statements, so it won't be run anyway.

moscas
  • 9,064
  • 36
  • 42