How to pass special characters as parameter in Stored Procedure

Database

How to pass special characters as parameter in Stored Procedure

Hi,

How can I pass special characters as input parameters to Stored Procedures. As of now I am particularly looking for brackets "(" , ")" and Single quote.

What is the maximum length of the Input Parameter which can be passed to Proc?

Thanks.

4 REPLIES

Re: How to pass special characters as parameter in Stored Procedure

Hi,

Actually the brackets within double quotes and w/o that also  worked :-) (which I mentioned to give example above). The issue is, I need to pass around 4000 char of i/p parameter and I am getting error: "string not terminated before end of text".

thanks.

N/A

Re: How to pass special characters as parameter in Stored Procedure

CALL DBA_DB1.CTBLS (
'CREATE SET TABLE ORDER1.PRODUCT ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      COL1  DECIMAL(15,0) NOT NULL,
      COL2  CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT 'N',
       COL3  DECIMAL(5,0) )
UNIQUE PRIMARY INDEX ( COL1 );'
,ERR);

How to Pass the Single quote which is in the second column .

Nambi

Teradata Employee

Re: How to pass special characters as parameter in Stored Procedure

To include a single quote within a string, enter two single quotes in a row, e.g. DEFAULT ''N'',

N/A

Re: How to pass special characters as parameter in Stored Procedure

Thanks fred it worked . Any way to replace these single quotes with double quotes using functions.