Hi, 

How can i use a user-defined type in ECPG code ? 

For example:

I have the following stored-procedure:
 CREATE FUNCTION teste(MY_TYPE) RETURNS boolean;

where MY_TYPE is:
 CREATE TYPE MY_TYPE AS (id_person INT8, id_book INT8);

Now, i am having problem with:

EXEC SQL SELECT teste(:asd);

-- 
 Andre  <[EMAIL PROTECTED]>




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to