Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. Function that just to fill an empty space ....

Function that just to fill an empty space ....

Scheduled Pinned Locked Moved The Weird and The Wonderful
databaseoracle
10 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    R Offline
    red_moon
    wrote on last edited by
    #1

    I found this on my friend's source code, I wonder the intention of this function .... :confused: He create a function on an Oracle database. FUNCTION f_init RETURN VARCHAR2 IS vssqlerrm VARCHAR2 (255); vsvalidation VARCHAR2 (255); BEGIN vssqlerrm := ''; vsvalidation := ''; RETURN vsvalidation; EXCEPTION WHEN OTHERS THEN BEGIN vssqlerrm := SQLERRM; vsvalidation := vssqlerrm; END; END;

    It's easy to laugh, but, it's so hard to smile ...

    P F A J 4 Replies Last reply
    0
    • R red_moon

      I found this on my friend's source code, I wonder the intention of this function .... :confused: He create a function on an Oracle database. FUNCTION f_init RETURN VARCHAR2 IS vssqlerrm VARCHAR2 (255); vsvalidation VARCHAR2 (255); BEGIN vssqlerrm := ''; vsvalidation := ''; RETURN vsvalidation; EXCEPTION WHEN OTHERS THEN BEGIN vssqlerrm := SQLERRM; vsvalidation := vssqlerrm; END; END;

      It's easy to laugh, but, it's so hard to smile ...

      P Online
      P Online
      PIEBALDconsult
      wrote on last edited by
      #2

      Maybe it's a template?

      R J 2 Replies Last reply
      0
      • R red_moon

        I found this on my friend's source code, I wonder the intention of this function .... :confused: He create a function on an Oracle database. FUNCTION f_init RETURN VARCHAR2 IS vssqlerrm VARCHAR2 (255); vsvalidation VARCHAR2 (255); BEGIN vssqlerrm := ''; vsvalidation := ''; RETURN vsvalidation; EXCEPTION WHEN OTHERS THEN BEGIN vssqlerrm := SQLERRM; vsvalidation := vssqlerrm; END; END;

        It's easy to laugh, but, it's so hard to smile ...

        F Offline
        F Offline
        fjdiewornncalwe
        wrote on last edited by
        #3

        Maybe he's still paid by line.

        I wasn't, now I am, then I won't be anymore.

        1 Reply Last reply
        0
        • R red_moon

          I found this on my friend's source code, I wonder the intention of this function .... :confused: He create a function on an Oracle database. FUNCTION f_init RETURN VARCHAR2 IS vssqlerrm VARCHAR2 (255); vsvalidation VARCHAR2 (255); BEGIN vssqlerrm := ''; vsvalidation := ''; RETURN vsvalidation; EXCEPTION WHEN OTHERS THEN BEGIN vssqlerrm := SQLERRM; vsvalidation := vssqlerrm; END; END;

          It's easy to laugh, but, it's so hard to smile ...

          A Offline
          A Offline
          AspDotNetDev
          wrote on last edited by
          #4

          PRE tags please!

          FUNCTION f_init
          RETURN VARCHAR2
          IS
          vssqlerrm VARCHAR2 (255);
          vsvalidation VARCHAR2 (255);
          BEGIN
          vssqlerrm := '';
          vsvalidation := '';
          RETURN vsvalidation;
          EXCEPTION
          WHEN OTHERS
          THEN
          BEGIN
          vssqlerrm := SQLERRM;
          vsvalidation := vssqlerrm;
          END;
          END;

          I'm not familiar with that language, but it looks a bit like it's a function that returns an empty string and has some unecessary exception handling. Quite the horror!

          [WikiLeaks Cablegate Cables]

          F J 2 Replies Last reply
          0
          • A AspDotNetDev

            PRE tags please!

            FUNCTION f_init
            RETURN VARCHAR2
            IS
            vssqlerrm VARCHAR2 (255);
            vsvalidation VARCHAR2 (255);
            BEGIN
            vssqlerrm := '';
            vsvalidation := '';
            RETURN vsvalidation;
            EXCEPTION
            WHEN OTHERS
            THEN
            BEGIN
            vssqlerrm := SQLERRM;
            vsvalidation := vssqlerrm;
            END;
            END;

            I'm not familiar with that language, but it looks a bit like it's a function that returns an empty string and has some unecessary exception handling. Quite the horror!

            [WikiLeaks Cablegate Cables]

            F Offline
            F Offline
            fjdiewornncalwe
            wrote on last edited by
            #5

            Sorry, but in this case the pre tags don't really help

            I wasn't, now I am, then I won't be anymore.

            A 1 Reply Last reply
            0
            • F fjdiewornncalwe

              Sorry, but in this case the pre tags don't really help

              I wasn't, now I am, then I won't be anymore.

              A Offline
              A Offline
              AspDotNetDev
              wrote on last edited by
              #6

              Yeah, some languages are hopeless. :)

              [WikiLeaks Cablegate Cables]

              1 Reply Last reply
              0
              • P PIEBALDconsult

                Maybe it's a template?

                R Offline
                R Offline
                red_moon
                wrote on last edited by
                #7

                No, it's not a template, cause it used in another routines. :)

                It's easy to laugh, but, it's so hard to smile ...

                1 Reply Last reply
                0
                • A AspDotNetDev

                  PRE tags please!

                  FUNCTION f_init
                  RETURN VARCHAR2
                  IS
                  vssqlerrm VARCHAR2 (255);
                  vsvalidation VARCHAR2 (255);
                  BEGIN
                  vssqlerrm := '';
                  vsvalidation := '';
                  RETURN vsvalidation;
                  EXCEPTION
                  WHEN OTHERS
                  THEN
                  BEGIN
                  vssqlerrm := SQLERRM;
                  vsvalidation := vssqlerrm;
                  END;
                  END;

                  I'm not familiar with that language, but it looks a bit like it's a function that returns an empty string and has some unecessary exception handling. Quite the horror!

                  [WikiLeaks Cablegate Cables]

                  J Offline
                  J Offline
                  Jorgen Andersson
                  wrote on last edited by
                  #8

                  aspdotnetdev wrote:

                  I'm not familiar with that language

                  Looks like PL-SQL to me.

                  List of common misconceptions

                  1 Reply Last reply
                  0
                  • R red_moon

                    I found this on my friend's source code, I wonder the intention of this function .... :confused: He create a function on an Oracle database. FUNCTION f_init RETURN VARCHAR2 IS vssqlerrm VARCHAR2 (255); vsvalidation VARCHAR2 (255); BEGIN vssqlerrm := ''; vsvalidation := ''; RETURN vsvalidation; EXCEPTION WHEN OTHERS THEN BEGIN vssqlerrm := SQLERRM; vsvalidation := vssqlerrm; END; END;

                    It's easy to laugh, but, it's so hard to smile ...

                    J Offline
                    J Offline
                    Jorgen Andersson
                    wrote on last edited by
                    #9

                    Have you asked your friend?

                    List of common misconceptions

                    1 Reply Last reply
                    0
                    • P PIEBALDconsult

                      Maybe it's a template?

                      J Offline
                      J Offline
                      Jorgen Andersson
                      wrote on last edited by
                      #10

                      PL-SQL supports overloading...

                      List of common misconceptions

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups