[ https://issues.jboss.org/browse/TEIIDDES-2355?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2355: ---------------------------------------- [~blafond] I've created a function in Oracle 11 DB: {code:sql} CREATE OR REPLACE FUNCTION get_edition(ISBNI IN VARCHAR2) RETURN NUMBER IS editionr NUMBER(1); BEGIN SELECT edition INTO editionr FROM books WHERE isbn = isbni; RETURN(editionr); END; {code} Then I've tried to import from this DB using Teiid Connection Import with "Import Procedures" property set to "true" This is the generated DDL: {code:sql} CREATE FOREIGN PROCEDURE GET_EDITION(OUT "return" bigdecimal(22) RESULT OPTIONS (NATIVE_TYPE 'NUMBER'), IN ISBNI string OPTIONS (NATIVE_TYPE 'VARCHAR2')) OPTIONS (NAMEINSOURCE '"GET_EDITION"') {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)