Hi,

In my ID system based on CHAR(16) OCTETS (aka UUID).
I've created a domain for it.

CREATE DOMAIN UUID AS
CHAR(16) CHARACTER SET OCTETS
COLLATE OCTETS;

I wrote few stored procedures to support support some complex operations.


Now I have to create a new one which have UUID local variables.

DECLARE VARIABLE V_PARENT UUID;

and

SELECT ...... INTO :V_PARENT;

WHILE (V_PARENT IS NOT NULL) DO
BEGIN
....
END

If the V_PARENT contains any kind of ' or " (string quote char) the
procedure stops with:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Malformed string.


Thanks
Zolee


[Non-text portions of this message have been removed]