I get an error when I call a function
<code>CREATE OR REPLACE FUNCTION test_funct(v_var VARHAR2) RETURN VARCHAR2 SQL_MACRO IS
BEGIN
RETURN q'{SELECT DUMMY FROM DUAL WHERE DUMMY = v_var}';
END;
/
</code>
<code>CREATE OR REPLACE FUNCTION test_funct(v_var VARHAR2) RETURN VARCHAR2 SQL_MACRO IS
BEGIN
RETURN q'{SELECT DUMMY FROM DUAL WHERE DUMMY = v_var}';
END;
/
</code>
CREATE OR REPLACE FUNCTION test_funct(v_var VARHAR2) RETURN VARCHAR2 SQL_MACRO IS
BEGIN
RETURN q'{SELECT DUMMY FROM DUAL WHERE DUMMY = v_var}';
END;
/
<code>SELECT * FROM test_funct('X');
</code>
<code>SELECT * FROM test_funct('X');
</code>
SELECT * FROM test_funct('X');
ORA-22905: cannot access rows from a non-nested table item