From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: 103376,f59d6c1c0a3dac5f X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news3.google.com!news.glorb.com!cycny01.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc07.POSTED!a5a7929f!not-for-mail Subject: Re: ada and pl/sql Newsgroups: comp.lang.ada From: ka@sorry.no.email (Kenneth Almquist) References: <122gh5o729tsfcf@corp.supernews.com> Message-ID: Date: Wed, 29 Mar 2006 18:04:05 GMT NNTP-Posting-Host: 70.21.231.120 X-Complaints-To: abuse@verizon.net X-Trace: trnddc07 1143655445 70.21.231.120 (Wed, 29 Mar 2006 13:04:05 EST) NNTP-Posting-Date: Wed, 29 Mar 2006 13:04:05 EST Xref: g2news1.google.com comp.lang.ada:3676 Date: 2006-03-29T18:04:05+00:00 List-Id: 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;