2 Replies Latest reply on Apr 17, 2013 9:01 PM by CJ the DBA

    How do you embed special characters in SQL Dev report & request parameter?

    CJ the DBA
      Greetings Gurus,

      I'm trying to port over a sqlplus report to SQL Developer. How do you embed a special character or return?

      select ' Action: &&V_PATCH &&V_ACTION' || chr(10) ||
      'Database: '|| instance_name || chr(10) ||
      ' Date: '||to_char(sysdate,'DD-MON-YYYY HH24:MI') || chr(10)
      from v$instance;

      script window output:

      Date: 16-APR-2013 19:19

      Expected Output:
      Action: 9714783 Patch Summary
      Database: dev5
      Date: 16-APR-2013 18:48

      *2nd Question:*
      How do you have the user respond for report inputs?

      define V_PATCH = &PATCH
      define V_SNAPSHOT = &SNAPSHOT_ID

      The &PATCH and &SNAPSHOT_ID windows pop up when I run it in the sql worksheet, but do not when I try to run them from via the report window. I get the following error in the login window:
      'Warning, unhandled exception: ORA-00922: missing or invalid option'

      Thanks in advance for your help!

      Best regards,
      Con O'Keeffe

      Edited by: user10401849 on Apr 16, 2013 12:27 PM

      Edited by: user10401849 on Apr 16, 2013 12:29 PM