Re: Return value of PL/SQL-functions

From: Stephan Huettner <sh_at_hackenberg.de>
Date: 1996/12/20
Message-ID: <32BAE449.492E@hackenberg.de>#1/1

Thanks for the information, Thomas. I now understand much better the behaviour of CHAR-PL/SQL functions. But we simply can't alter every SELECT-Statement in our applications the way you suggested.

A deeper look into the standard package of oracle (standard.sql) showed the definition of SUBSTR(). SUBSTR() itself calls a function pessub().

function SUBSTR( STR1 VARCHAR2, POS BINARY_INTEGER,

                LEN BINARY_INTEGER := NULL )
        return varchar2 is
  begin
        retunr pessub( STR1, POS, LEN );

  end SUBSTR;

I think, it should be possible to call internal functions like pessub() within PL/SQL functions. This way we could possibly define PL/SQL functions that behave like SUBSTR() with their return values. Are these internal functions documented? What do I have to do to make use of them?

Thanks a lot

Stephan Hüttner
Hackenberg & Partner
Germany Received on Fri Dec 20 1996 - 00:00:00 CST