Re: ada and pl/sql

[ka@sorry.no.email (Kenneth Almquist)]

Jason King wrote:
> declare
>    v1 varchar2(10) := 'Hello';
>    v2 varchar2(10) := 'World';
>    v3 varchar2(30);
> begin
>    v3 := v1 || ' ' || v2 ; -- || is string concat operator.
>                            -- no error here since 'Hello World'
>                            -- fits.
>    dbms_output.put_line(v3) ; -- prints "Hello World"

As others have said, Ada's unbounded_string type is probably what
you are looking for.  For this particular example, the Ada string
type will also work:

  declare
     v1 : constant string := "Hello";
     v2 : constant string := "World";
     v3 : constant string := v1 & ' ' & v2;   -- & is string concat operator.
  begin
     ada.text_io.put_line(v3);     -- prints "Hello World"
  end;