1 Reply Latest reply on Jan 11, 2019 2:16 AM by Gaz in Oz

    Variable is a NUMBER but APEX EXPORT doesn't accept it

    Franco Soldera

      SQLcl: Release 18.3 Production on Tue Jan 08 09:12:46 2019

       

      Copyright (c) 1982, 2019, Oracle.  All rights reserved.

       

      Last Successful login time: Ti Jan 08 2019 09:12:47 +01:00

       

      Connected to:

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      SQL> VARIABLE appid NUMBER

      SQL> EXEC :appid := 250;

       

      PL/SQL procedure successfully completed.

       

      SQL> PRINT :appid

       

           APPID

      ----------

             250

       

      SQL> APEX EXPORT -applicationid :appid

      APEX: Application export requires an application id (numeric).