Gabor Koch wrote : >Please help me: >I want create dbproc with unicode parameter, but
>the following sql >CREATE DBPROC test (IN par1 VARCHAR(20) UNICODE) AS RETURN 1; >is generate error message : Syntax error or access violation;-3008 pos(42); >invalid keyword or missing delimiter >if i try the next then everyting is ok >CREATE DBPROC test (IN par1 VARCHAR(20)) AS RETURN 1; >parameter _UNICODE is YES, and i can create table with unicode filed. The documentation says that only the datatypes BOOLEAN, CHAR[ACTER], DATE, FIXED, FLOAT, INT[EGER], NUMBER, REAL, SMALLINT, TIME, TIMESTAMP, and VARCHAR can be used as the data type of a formal parameter of a database procedure. The specification of UNICODE therefore is not allowed, but is assumed implicitly in an unicode environment. Just omit UNICODE and everything will work as expected. This is because in a unicode environment db-procedures always work on UCS-2 data internally. Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
