how do i concate a string in pl/sql

[2314]

how do i concate a string in pl/sql what i really need is to create a long sql select string in store procedure pass paramters to it and get back the value

 

[hoinz]

do you mean this:
string1 || string2

 

[2314]

what is want is to do this

create procedure getlastdgt(cmpny_cd varchar2(3),ctgry_cd varachar2(3),STR out VARCHAR2(200)) as
begin
str:='Select LST_DGT from EPAYPARAMETER where CMPNY_CD' || ''' || cmpny_cd || ''' || 'and ctgry_cd=' || ''' || || ctgry_cd || '''
print :str;
end
/

but i am getting errors

 

[sem]

String literal ' is denoted as '''' (quoted quotes must be doubled). Alternatively you may use CHR(39) instead.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

2314,

Here is completed code that returns what you want:

create or replace procedure getlastdgt
    (cmpny_cd varchar2,ctgry_cd varchar2,STR out VARCHAR2) as
begin
    str:='Select LST_DGT from EPAYPARAMETER where CMPNY_CD = ''' ||
        cmpny_cd ||''' and ctgry_cd = ''' ||ctgry_cd || '''';
end;
/

Procedure created.

var whatever varchar2(200)
var company varchar2(10)
var category varchar2(10)
exec :company := 'ABC'
exec :category := 'XYZ'
exec getlastdgt(:company,:category,:whatever)
select :whatever from dual;

Select LST_DGT from EPAYPARAMETER where CMPNY_CD = 'ABC' and ctgry_cd = 'XYZ'

Let us know if this is what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 16:08 (21Oct04) UTC (aka "GMT" and "Zulu"),
@ 09:08 (21Oct04) Mountain Time