need to use single quote in procedure input argument while using in select query

Hi,

I need to add single quote to my input variable of procedure while using in select query

Code:

create or replace procedure listobj(objnam varchar)

    is

    cursor c1 is

    select object_id,object_name,tablespace_name,owner from dba_objects where object_name=objnam;

    rec c1%rowtype;

    begin

    for rec in c1 loop

    dbms_output.put_line(rec.object_id||'  '||rec.tablespace_name||'  '||rec.owner);

    end loop;

   end;

   /

0down votefavorite

I need to add single quote to my input variable in procedure being used in select query. <span class="kwd" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; color: #101094;">create</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; color: #303336;"> </span><span class="kwd" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; color: #101094;">or</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;