1 Reply Latest reply: Jul 3, 2013 7:34 AM by Jeff Smith Sqldev Pm-Oracle Branched to a new discussion. RSS

    12c support?

    523861

      Hi guys - this is a partial cross-post from here:

      https://forums.oracle.com/message/11092543#11092543

       

      mods feel free to delete if necesary.

       

      I am running SQL developer 3.2.20.09 on database as follows:

       

      BANNER                                                                               CON_ID
      -------------------------------------------------------------------------------- ----------
      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0
      PL/SQL Release 12.1.0.1.0 - Production                                                    0
      CORE 12.1.0.1.0 Production                                                                  0
      TNS for Linux: Version 12.1.0.1.0 - Production                                            0
      NLSRTL Version 12.1.0.1.0 - Production                                                    0
      

       

       

      but it seems that it does not support plsql program components in the with clause:

       

      as the example in the documentation here:

      http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_10002.htm#BABJFIDC

       

      with function getdomain(v_email varcahr2) 
             return varchar2 
             is
                v_domain varchar2(100);
             begin
                v_domain := regexp_replace(v_email,'.*@(.*)','\1');
                return v_domain;
             end;          
      select email_address, getdomain(email_address)
        from customer_email
        where email_id = 8
        /
      

       

      this behaves as if it doesn't know the syntax, giving the error:

       

      Error starting at line 1 in command:
      with function getdomain(v_email varcahr2) 
             return varchar2 
             is
                v_domain varchar2(100)
      Error at Command Line:1 Column:6
      Error report:
      SQL Error: ORA-06553: PLS-103: Encountered the symbol "end-of-file" when expecting one of the following:
      
      
         := ; not null default character
      06553. 00000 -  "PLS-%s: %s"
      *Cause:    
      *Action:
      

       

       

      Of note is that I'm connecting using an 11g client installed on my pc, would this make a difference?