Recent content by John Owen

  1. J

    Function Edit and compile gives error

    CREATE OR REPLACE FUNCTION "F_SUBLEDGERTYPELOOKUP2" (v_compno IN VARCHAR, v_orgunit IN VARCHAR2, v_vendcat IN VARCHAR2, v_vendno IN VARCHAR2, v_countrycd IN VARCHAR2, v_statgrp IN VARCHAR2 ) RETURN VARCHAR2 IS -- PL/SQL Specification v_accountstring VARCHAR2(30); v_subledgertype...
  2. J

    Function Edit and compile gives error

    You're right, if a de-select this option then it works o.k. Ideally I'd prefer to use the safe option so that I don't screw anything up, but until the bug is fixed in a later version atleast this is a workaround I can use.
  3. J

    Function Edit and compile gives error

    I've upgraded to the latest version (6.0.4.906), and still the same.
  4. J

    Function Edit and compile gives error

    Version 6.0.3.893
  5. J

    Function Edit and compile gives error

    In the all objects list, by editing a function, but not changing it. When I compiled it I get compiled with errors. Somehow PL/SQL Developer has changed the last line of the script and instead of END functionname; in Oracle it now reads END P$24041926$; Since P$24041926$ was not my funtion...
  6. J

    Enhancement: Views - Instead Of

    I'm running 6.0.3.893 trial version and it is not saving and restoring the instead of triggers when you compile a view. Is this a feature only of the trial version ?
See more
Back
Top