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?
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".
CALL DBA_DB1.CTBLS (
'CREATE SET TABLE ORDER1.PRODUCT ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
COL1 DECIMAL(15,0) NOT NULL,
COL2 CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT 'N',
COL3 DECIMAL(5,0) )
UNIQUE PRIMARY INDEX ( COL1 );'
How to Pass the Single quote which is in the second column .
To include a single quote within a string, enter two single quotes in a row, e.g. DEFAULT ''N'',